MS SQL Monitoring Issue: ntwdblib.dll not found

keith_b · Post by **keith_b** » Thu Aug 06, 2009 10:47 am

Running hostmon 7.10 on a Windows Server 2008 (Enterprise x64 SP1) system, I am trying to monitor MS Sql databases on the network.

When I attempt to monitor a specific DB on another server (also running Windows Server 2008 Enterprise x64 SP1) that is using MS SQL Server 2008 it fails. MS SQL 2008 is also installed on my server that is running Hostmon. Both the Hostmon server, and the target monitored server are running the exact same version of SQL and MDAC:

Microsoft SQL Server Management Studio Version = 10.0.2531.0
Microsoft Data Access Components (MDAC) Version = 6.0.6001.18000

Anyway, still getting the ntwdblib.dll not found error when I try to monitor the DB. Any ideas? I'm not sure what else to do because all the current proper runtimes are installed on both servers.

KS-Soft · Post by **KS-Soft** » Thu Aug 06, 2009 11:51 am

Do you have installed this DLL on your system? ntwdblib.dll is not part of HostMonitor, its part of MS SQL client.
You may download just DLL at www.ks-soft.net/download/ntwdblib.zip

Regards
Alex

keith_b · Post by **keith_b** » Thu Aug 06, 2009 11:59 am

Yes I actually tried that already (saw that solution in another thread here).... and it didnt work.

I stopped the hostmon service (and made sure i had no other instances running), and then moved the .dll into the hostmon program directory. Upon startup of the application again when hostmon attempted to use that .dll to contact the remote DB, I got a second error message saying that "msvcr71.dll" was missing also.

It doesn't appear that msvcr71.dll is going to work on x64 server 08 (after a quick search).

KS-Soft · Post by **KS-Soft** » Thu Aug 06, 2009 12:17 pm

Actually HostMonitor offers ODBC Query test method that can work with any database and offers more options for monitoring.
Do you have MS ODBC driver installed?

Regards
Alex

keith_b · Post by **keith_b** » Thu Aug 06, 2009 12:19 pm

I'm not sure, but I will give that a shot and get back to you.

keith_b · Post by **keith_b** » Thu Aug 06, 2009 2:14 pm

Ok so it looks like I'm halfway there...

I fired up the ODBC manager in windows and configured a new system DSN to connect to the remote DB. The connection (from the ODBC manager) works fine and connected successfully.

However, when I open up hostmon again... and try and make a new ODBC test, I get the following error message when I specify my newly made ODBC system DSN:

"Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."

It appears as if Hostmon can't see my ODBC driver (and consequently can't see the DSN name). Did I miss a step here? Only thing I saw in the hostmon options was the ability to specify user or system DSNs (and I made sure system DSN's was selected).

KS-Soft · Post by **KS-Soft** » Thu Aug 06, 2009 2:29 pm

Have you used 32-bit ODBC Data Source Administrator to setup data source?
Quote
==============
If you are using Windows x64 Edition and you want to setup ODBC Logging or ODBC test method, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).
==============

Regards
Alex

keith_b · Post by **keith_b** » Thu Aug 06, 2009 2:44 pm

AWESOME!!!!

Switching it over to the 32-bit ODBC did the trick. Hostmon is now monitoring SQL.

Seriously, thanks for your help. That saved me a lot of time.

KS-Soft · Post by **KS-Soft** » Thu Aug 06, 2009 3:13 pm

No problem

Regards
Alex