Configure the ODBC driver for large data sets

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

Before you begin

Role required: admin

About this task

These properties are set using the ODBC Management Console that is available on Windows operating systems. For more information, see ODBC management console properties.

Procedure

  1. Open the ODBC Management Console available from the Start menu.
  2. Navigate to ServiceNow ODBC > Management Console.
  3. Navigate to Data Source Settings > ServiceNow > IP Parameters
  4. Set the Timeout property to be more than the glide.soap.request_processing_timeout.odbc value.
  5. Navigate to Services > Service Settings > SQL Engine Parameters
  6. Increase the ServiceSQLDiskCacheMaxSize property.
    Typically, when running a query that returns 50,000 rows, the default value of 200 must be increased.