Test SQL API ODBC driver connection using Interactive SQL

Run the Interactive SQL application for quick verification of connectivity and to test query results without using a full application.

Before you begin

Role required: local administrator on client machine

Procedure

1. Navigate to the Start Menu.
2. Select and hold (or right-click) on the Interactive SQL (ODBC).
3. Select Run as Administrator.
4. Use this command format to connect to your ServiceNow instance database using the ODBC driver:

   connect “username”*”password”@”dsn_name”

   For example:

   connect "odbc.user"*"TestSQLAPI"@”servicenow”

5. Issue a SELECT SQL command.

   SELECT NUMBER, short_description FROM incident;

   Include the semicolon at the end of your query statement. Otherwise, the system displays a 'Cont>' prompt.