---
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


---

# Configure the ODBC driver for large data sets

# Configure the ODBC driver for large data sets {#ariaid-title1}

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

You can set two ODBC driver properties to deal with errors you receive when using
queries that return large amounts of data.

## Vorbereitungen

You must have administrator-level access for the Windows computer on which you want to configure the ODBC driver for large data sets.

## Warum und wann dieser Vorgang ausgeführt wird

These properties are set using the ODBC Management Console available on Windows operating systems. For more information, see [ODBC management console properties](https://servicenow-prod.fluidtopics.net/DiZleuB8DCM4_fgdm6aJdA#r_SettingODBCProperties__ODBC_mgmt_console_properties).

## Prozedur

1. In Windows, navigate to StartProgramsServiceNow ODBCManagement Console.
2. Navigate to Data Source SettingsServiceNowIP Parameters.
3. Set the Timeout property to be more than the glide.soap.request_processing_timeout.odbc value in seconds.  
   ODBC makes SOAP calls on the instance. The glide.soap.request_processing_timeout.odbc system property is the timeout for the ODBC driver.
4. Navigate to ServicesService SettingsSQL Engine Parameters.
5. Increase the ServiceSQLDiskCacheMaxSize property.  
   Typically, when running a query that returns 50,000 rows, the default value of 200 MB must be increased.
{#configure-odbc-large-data-sets__steps_ks1_nhv_s1b}