Configure the ODBC driver for large data sets

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 1분

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

    시작하기 전에

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

    이 태스크 정보

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

    프로시저

    1. In Windows, navigate to Start > Programs > ServiceNow ODBC > Management Console.
    2. Navigate to Data Source Settings > ServiceNow > IP 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 Services > Service Settings > SQL 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.