Test SQL API ODBC driver connection using Interactive SQL

  • Release version: Zurich
  • Updated March 7, 2026
  • 1 minute to read

    • 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. Go 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.

      Sample SQL Query.