Joe,
Thanks for the info. I considered the loss of this setting a nuisance
since I figured out how to go about making it work again. I saw the
reply from Bruce who said he set it up with a System DSN instead of the
User DSN and I'll test it later when I have more time, but your comments
about it being set up in the User DSN made total sense and would
definitely explain the oddity since I log in with the WUG Domain Service
account most of the time that we created to let it access the NT servers
in the domain as needed without a lot of hassles and to let me keep the
system as consistent as we can to avoid any surprises.
One other nuisance that I haven't had time to dive into yet, but
something we noticed when running the various reports (including the
Outage Report) and comparing the various performance reports for
different servers where the number of outages is reported, we noticed
that they rarely equal for the same period of time with the
Pre-Configured Outage report... Why is this, isn't an outage an outage
regardless of how long it is?
Because of this anomaly, our management has shied away from using the
WUG reports so I haven't spent too much time trying to figure it out as
I mainly use WUG for an outage detector and T-shooting tool to quickly
isolate where a problem is based on what I can and can't see?
Thanks again!
------------------------------------------------------------
Bryan Harrell, SPII
Network Infrastructure - Tallahassee
Fla. Dept of Revenue
(850)-921-0700 SunCom 291-0700
------------------------------------------------------------
[EMAIL PROTECTED] 11/08/2005 1:11:06 PM >>>
Bryan you are correct you don't need to restart WhatsUp Gold when you
make
ODBC DSN changes.
Note that we are using a user DSN and not a system DSN. So if you
installed as one user id and then login with another user id you will
not
have the wugstatdata and WUGSNMP DSN's.
Here is how the system works:
WUG writes performance stats data to the ST-yyy-mm-dd.tab files on a
hourly basis (by default).
Each time you run a report the data gets written to the
wugstatsdata.tab
file.
Cstatrpt.exe uses the Crystal Reports API to access data in
wugstatsdata.tab via the ODBC DSN.
Regards,
Joe
On Tue, 08 Nov 2005 08:30:54 -0500, Bryan Harrell
<[EMAIL PROTECTED]> wrote:
Yea, this happens to me occasionally and I haven't figured out what
it
is that causes WUGSTATDATA to disappear, but searching on your error
message ("Cannot Open SQL server.") in the knowledge base will give
you
this link to check out and has always solved this issue for me (in
fact
I keep it book marked with the rest of my WUG book marks so I can
avoid
having to search for it every time). The final thing it asks you to
do
is to restart WUG after it's been configured, but I've never had to
do
that to get a report out of it, so give the instructions a try as far
as
getting the data source configured and then run your report:
http://support.ipswitch.com/kb/WG-20000306-DM01.htm
------------------------------------------------------------
Bryan Harrell, SPII
Network Infrastructure - Tallahassee
Fla. Dept of Revenue
(850)-921-0700 SunCom 291-0700
------------------------------------------------------------
[EMAIL PROTECTED] 11/07/2005 4:54:34 PM >>>
I also created it as a System DSN which I would think is appropriate
for
access by an NT Service. Same thing. The book also says that the
data
is
stored in wugstats.log which doesn't exist on my server.
If someone could take the time, please post your ODBC settings for
this. I
am running Wug 8.04
Thanks,
bruce meyer
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Meyer,
Bruce
Sent: Monday, November 07, 2005 4:39 PM
To: '[email protected]'
Subject: [WhatsUp Forum] Problems with reports
I am trying to generate some of the canned reports.
When I click on 'Do Report' of Avail_Month I get;
Cannot Open SQL server.
In the focus bar it says:
Report Job Failed. Error: 599:2 Avail_Month
Doing some research It seems it is trying to use a Data Source
named;
wugstatdata.tab
I see in my ODBC configuration no such, file, system or user DSN
exists.
I look at page 10 of the book and it seems that if it doesn't exist,
I
can
create it.
So I select user DSN, and Microsoft txt driver, then select the path
to
the
file named
wugstatdata.tab which is:
c:\program files\whatsup
gave it the DSN name of WUGSTATDATA.TAB
and description of Whats Up gold user DSN.
Restarted WUG, and it still doesn't seem to be able to create the
report. I
found no reference to this on their web site.
ODBC was installed prior to installing WUG over a year ago. I don't
know if
the reports ever worked or not.
Any help will be appreciated.
Bruce D. Meyer, CCNA, MCSE
Network Analyst
City of Columbia, SC
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
