View previous topic :: View next topic |
Author |
Message |
Stan White
Joined: 23 Jul 2014 Posts: 10 Location: United States
|
Posted: Fri Aug 29, 2014 2:38 pm Post subject: Error when doing a SQL Server Test |
|
|
I get an error message "Dynamic library ntwdblib.dll not found" when adding the Hostmon SQL Server test.
Where is this "dll" file supposed to be? How do I resolve this problem? |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Fri Aug 29, 2014 2:43 pm Post subject: |
|
|
"MS SQL server check" test method is obsolete. We keep it for backward compatibility.
We recommend to use ODBC Query test instead: http://www.ks-soft.net/hostmon.eng/mframe.htm#tests.htm#odbc
For ODBC test you will need to setup ODBC driver using 32-bit ODBC Data Source Administrator.
Please note: If you are using 64bit Windows OS and you want to setup ODBC Logging or ODBC test method, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (default path: C:\WINDOWS\SysWOW64\odbcad32.exe).
If you still need to use "MS SQL server check" test, you may try to download dll at:
http://www.ks-soft.net/download/ntwdblib.zip
and copy it into HostMonitor folder. |
|
Back to top |
|
|
Stan White
Joined: 23 Jul 2014 Posts: 10 Location: United States
|
Posted: Fri Aug 29, 2014 3:24 pm Post subject: ODBC Data Source Administrator... ??? |
|
|
I am not sure what the ODBC Data Source Administrator does and how to set it up?
I will need to run SQL Server scripts and I guess I need to know what I need to do to get this accomplished through Hostmon. |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Fri Aug 29, 2014 3:55 pm Post subject: |
|
|
In order to use ODBC driver to connect to SQL Server, you need to configure ODBC data source using ODBC Data Source Administrator.
Afret configuring data source, it can be selected in HostMonitor.
Default location of ODBC Data Source Administrator is:
For 64-bit systems: C:\WINDOWS\SysWOW64\odbcad32.exe
For 32-bit systems: C:\WINDOWS\System32\odbcad32.exe |
|
Back to top |
|
|
Stan White
Joined: 23 Jul 2014 Posts: 10 Location: United States
|
Posted: Tue Sep 02, 2014 10:04 am Post subject: ODBC for SQL Server |
|
|
I started to set up the ODBC which you said, however the ODBC Administrator does not tell me how Hostmon will connect to the SQL Server database on another server.
When I am adding a test to check the size of tables on other servers, I need to know what to do in Hostmon to make that happen.
Thanks |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Tue Sep 02, 2014 10:30 am Post subject: |
|
|
ODBC Data source should be configured on HostMonitor system.
This Data source name should be selected in HostMonitor. |
|
Back to top |
|
|
|