How to check SQL Express Server using native connection
How to check SQL Express Server using native connection
Hi there I have RMA client on all sites with SQL Express. We dont use ODBC connections. How can I Check DB and how do I run an query to return DATA ?
-
KS-Soft Europe
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
You may check database using "MS SQL check" test method: http://www.ks-soft.net/hostmon.eng/mfra ... #chkOracle
To make this test work properly with SQL Express, you should copy ntwdblib.dll into HostMonitor and RMA folder. ntwdblib.dll is a part of MS SQL Client 2000, but it is not supplied with SQL Express. You may download it from our site: http://www.ks-soft.net/download/ntwdblib.zip
If you want to execute SQL query and return data back to HostMonitor, you should use "ODBC query" test method: http://www.ks-soft.net/hostmon.eng/mfra ... s.htm#odbc
As alternative, you may create some VB or JS script, that connects to SQL server using OLEDB and start this script using "Active Script" test method: http://www.ks-soft.net/hostmon.eng/mfra ... htm#script
Regards,
Max
To make this test work properly with SQL Express, you should copy ntwdblib.dll into HostMonitor and RMA folder. ntwdblib.dll is a part of MS SQL Client 2000, but it is not supplied with SQL Express. You may download it from our site: http://www.ks-soft.net/download/ntwdblib.zip
If you want to execute SQL query and return data back to HostMonitor, you should use "ODBC query" test method: http://www.ks-soft.net/hostmon.eng/mfra ... s.htm#odbc
As alternative, you may create some VB or JS script, that connects to SQL server using OLEDB and start this script using "Active Script" test method: http://www.ks-soft.net/hostmon.eng/mfra ... htm#script
Regards,
Max