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

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Test the ODBC driver

# Test the ODBC driver {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

After configuring the ODBC driver, test that the driver can connect to the base
instance as the ODBC user and can query data from a target table.

## Before you begin

You must have administrator-level access for the Windows computer on which you want to test the ODBC driver.

## About this task

To test the connection, run the ODBC Administrator program.

## Procedure

1. In Windows, navigate to StartProgramsServiceNow ODBCODBC Administrator.  
   The ServiceNow ODBC data source is installed as a system data source.
2. Select the System DSN tab, and then select the ServiceNow data source.
3. Click Configure.  
4. Click Test Connect in the ODBC driver Setup dialog box.  
5. Enter the login credentials.  
   These are the usual ServiceNow base system
   login credentials for the ODBC user you created.  
6. Click OK to log in to the data source.
7. Click OK again when the success message appears.
* **[Generate logs for debugging](https://servicenow-prod.fluidtopics.net/7O0VCM8Nt_A66o27fVVMbQ)**   
  If you experience unexpected behavior when using the ODBC driver, you can enable debug logging and generate debug logs to help identify the issue.
* **[Test a query](https://servicenow-prod.fluidtopics.net/~eywTLouQgLMU3k2Zc7EpA)**   
  To verify that the user has the appropriate permissions to send requests to the instance using ODBC, run a query using Interactive SQL.
* **[ODBC troubleshooting](https://servicenow-prod.fluidtopics.net/Ef5I~1pjet0v0R3GB5Chgw)**   
  Review these troubleshooting resources to resolve issues with the ODBC driver.

**Related tasks**   

* [Configure the ODBC driver](https://servicenow-prod.fluidtopics.net/jChNHwmycdIQwGtlfbCWSg "Configure the ODBC driver to connect to your ServiceNow instance.")

*[\>]: and then