ODBC
From ServersCheck Wiki
Contents |
Description
The ODBC check allows you to connect to a database server with the specified ODBC string connection string. With this check you can check if database servers are up and running.
Definition
Besides the general settings for each check, which are similar for all checks, there are following specific settings that also need to be established. In the Check Specific Settings, there are following fields you need to supply with parameters:
- Database Templates - If you are unfamiliar with DSN-less ODBC connections, then you can select an ODBC connection template and match it to your configuration.
- ODBC Connection string - The ODBC connection string for validation.
Sample ODBC Connection Strings
Oracle ODBC Driver:
Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword
Microsoft Oracle ODBC Driver:
Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=myUsername;Pwd=myPassword
Informix 3.30 ODBC driver:
Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
Pervasive ODBC driver:
Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname
Microsoft SQL ODBC driver:
Driver={SQL Server}; Server=(local); Database=myDBName; UID=sa; PWD=;
MS SQL 2008: Driver={SQL Server Native Client 10.0}; Server=enter_IP_here; Database=enter_db_name_here; UID=enter_account_name_here; PWD=enter_password_here;
Microsoft Access ODBC driver:
Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\myDBName.mdb
Microsoft Excel:
Driver={Microsoft Excel Driver (*.xls)};DBQ=physical path to .xls file; DriverID=278;
Text File:
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=physical path to .txt file;
Returned Results
This check returns one result: could a connection be made to the server.
If you have Fail On Value 1 or Value 2 activated, it will have no impact as this check does not return any values.
Graphs
When the graphing option is activated then ServersCheck will produce for this check two graphs: Service Level, Availability.
MS SQL 2008 Native Client
The ODBC based checks can also be used using the latest connection drivers shipped with MS SQL 2008: Microsoft SQL Server 2008 Native Client.
The Microsoft SQL Server 2008 Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.
X86 Package (sqlncli.msi) - 4549 KB: http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409
