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.

Parent Topic:Configuring SQL API