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/
