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

 Release :

    - australia

ft:locale :

    - de-DE

ft:publication_title :

    - Australia API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Use Interactive SQL with ODBC

# Use Interactive SQL with ODBC {#ariaid-title1}

* Freigeben Version: Australia
* 
* Aktualisiert 12. März 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 Minute Lesedauer

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

## Vorbereitungen

Role required: admin

## Prozedur

1. In Windows, navigate to StartProgramsServiceNow ODBCInteractive SQL (ODBC).
2. Connect to the base instance by entering the following command and selecting the appropriate user credentials in the format without special characters: ID\*password@DSNName.  

       CONNECT odbcuser*password@ServiceNow

3. Issue a `SELECT` SQL command.  

       SELECT NUMBER, short_description FROM incident;

   Make sure to include the semicolon at the end of your query statement. Otherwise, you are presented with a `'Cont>'` prompt.  
* **[Specify the maximum number of rows returned](https://servicenow-prod.fluidtopics.net/DtCVYwI5kGxifz08sQXwQg)**   
  By default, ServiceNow only returns 100 rows of data with each iSQL query. If you need to return more rows of data, set the maxrows parameter for the iSQL session.
* **[SQL support](https://servicenow-prod.fluidtopics.net/k3yXvt1o5Gat5QchPb33xQ)**   
  The ODBC driver embeds a third party SQL/ODBC engine from DataDirect, a division of Progress Software.