Question
· Jan 7

How does Cache handle client-side query timeouts (ODBC / SQL Server linked server)?

Hello,

We are accessing an InterSystems Cacha database from Microsoft SQL Server using a linked server over ODBC (ODBC35). Queries are executed using OPENQUERY.

On the SQL Server side, there is a linked server property called Query Timeout. By default it is set to 0 (no timeout). We are considering setting it to 15 seconds and would like to understand how Cache behaves in this scenario.

Specifically, I would like clarification on the following points:

  1. When SQL Server sets a query timeout (for example, 15 seconds), is this timeout visible to or enforced by Cache itself, or is it handled entirely on the client/ODBC driver side?
  2. Does the Cache ODBC driver honor the ODBC attribute?
    • Is the timeout enforced during query execution?
    • Or only during row fetching?
    • Or not enforced at all?
  3. If SQL Server times out and cancels the request:
    • Does Caché stop executing the query immediately?
    • Or can the query continue running on the Caché server in the background?
Product version: Caché 2018.1
Discussion (3)2
Log in or sign up to continue