MS SQL Query possible?

rcanas · Joined: 06 Dec 2023 Posts: 1

Hello,

I was wondering if it is possible to have a test that runs an MS SQL query and returns the answer. I don't require anything complex, just make a query to a database to verify that it is operational and can read/return data.

Thanks
R

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

ODBC Query test
https://www.ks-soft.net/hostmon.eng/mframe.htm#tests.htm#odbc

System requirements
https://www.ks-soft.net/hostmon.eng/index-sysreq.htm

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