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/
