---
sourceDocument: Australia API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/api-reference

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Test Live Connect ODBC driver connection

# Test Live Connect ODBC driver connection {#ariaid-title1}

Release version: Australia  
Updated March 7, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Use Interactive SQL to verify that the ODBC driver connects to your ServiceNow instance and returns query results.

## Before you begin

The ODBC driver is configured on your client machine. See [Configure ServiceNow Live Connect ODBC driver on a client machine](https://servicenow-prod.fluidtopics.net/H~h09i~9er~caBlg1mJxog "Configure the ODBC driver with your instance URL, BCFIPS JAR file paths, and authentication credentials to enable BI tools to access your ServiceNow data.").

Role required: administrator

## Procedure

1. From the Start menu, select and hold (or right-click) Interactive SQL (ODBC), then select Run as administrator.
2. To connect to your ServiceNow instance, enter the following command:  
   * Basic authentication:

         connect "username"*"password"@"dsn_name"

     Example:

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

   * OAuth authentication: OAuth credentials are handled automatically through your DSN configuration. Use `connect @"dsn_name"`.

   {#test-sql-api-odbc-driver-connection-using-interactive-sql__ul_c45_nly_hkc}

   Replace `username`, `password`, and `dsn_name` with your respective credentials. DSN is configured in [Configure ServiceNow Live Connect ODBC driver on a client machine](https://servicenow-prod.fluidtopics.net/H~h09i~9er~caBlg1mJxog "Configure the ODBC driver with your instance URL, BCFIPS JAR file paths, and authentication credentials to enable BI tools to access your ServiceNow data.").  
   A confirmation message appears if the connection is successful.
3. To verify the connection returns data, enter a SELECT query.  
   Example:

       SELECT NUMBER, short_description FROM incident;

   Include the semicolon at the end of the query. Without it, a `Cont>` prompt appears.  
   The query results appear, displaying incident numbers and descriptions from your instance.

## Result

The ODBC driver connection is verified. You can use the driver with BI tools and data analysis platforms to query your ServiceNow data.