This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I keep getting and error running a query in Microsoft Access 2007
"ODBC call failed" [Informix][Informix ODBC Driver] Timeout expired (#-11094) [Informix][Informix ODBC Driver] Statement interrupted by user. (#-213)"
It only happens when I query large sets of data. If I filter data to small amounts the query returns my results with no error. Why can't I return large amounts of data? Seems like the server I am connecting to is breaking off the connection.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
That depends on what library you're using to connect to the database. Are you using ADO or DAO? Each has a slightly different way to do it. Use the Object Browser (F2) and search the library for "timeout".
Where do you adjust the timeout in Access 2007? I tried in the Access Options section but nothing happened. Then I read it had to be done somewhere in the registry?
Hi,
I don't use Informix but DB2 (via ODBC). For same problems I use PassThrough queries.
Ciao Mimmo
Thanks Tom! I will give that a try
That would be a good question for an Informix forum.
Why don't you believe the error message: it's taking too long to run your query given the connection settings that are in play. You may want to increase the connection timeout.