Access 2002 ODBC Timeout Issue
Desktop PC was recently upgraded (replaced would be a better term) with Access 2002 XP version and Informix SDK 2.81. This installs ODBC 3.82. An Access application that performed query's against Sysmaster (using links to systabnames and sysptnhdr) for statistics gathering now fails with an ODBC error: [Informix][Informix ODBC Driver]Timeout expired. (#-11094)[Informix][Informix ODBC Driver][Informix]Statement interrupted by user. (#-213) The ODBC connection test's ok and opening the link's to systabnames and sysptnhdr individually returns data with no issues. No changes have been made to the server. Checking the IBM/Informix defects list didn't show anything. Any suggestions? Thanks, Fred Prose Az Supreme Court
I recommend increasing the timeout both in the ODBC driver and the Access query. If you are using Windows XP, enable the Administrative Tools menu first: * Right click on the task bar and choose "Properties" * Choose "Customize" on the "Start Menu" tab * Turn on the "Administrative Tools" menu To increase the ODBC driver timeout: * Select Programs / Administrative Tools / Data Sources (ODBC) * Click on the "Connection Pooling" tab * Double click on "IBM INFORMIX 3.82 32 BIT" * Enable "Pool Connections to this driver" * Set the timeout you require A search for "timeout" in the online help facility in Access 2002 returns: "Set multiuser query options Specify how long before a query displays an ODBC time-out error A query that uses an ODBC database as its underlying source of data might encounter delays due to network traffic or heavy use of the ODBC server. 1. Open a query in Design view. 2. Select the query by clicking anywhere in query Design view outside the design grid and the field lists. 3. Click Properties on the toolbar to display the query's property sheet. 4. Set the ODBCTimeout property to the number of seconds that the query waits before displaying a time-out error. The default is 60 seconds. Note: If you set the property to zero, no time-out error occurs." Regards, Doug Lawry www.douglawry.webhop.org "Fred Prose" <fprose@hotmail.com> wrote in message news:195a4770.0311030816.7440be5e@posting.google.com... > Desktop PC was recently upgraded (replaced would be a better term) > with Access 2002 XP version and Informix SDK 2.81. This installs ODBC > 3.82. > > An Access application that performed query's against Sysmaster (using > links to systabnames and sysptnhdr) for statistics gathering now fails > with an ODBC error: > > [Informix][Informix ODBC Driver]Timeout expired. > (#-11094)[Informix][Informix ODBC Driver][Informix]Statement > interrupted by user. (#-213) > > The ODBC connection test's ok and opening the link's to systabnames > and sysptnhdr individually returns data with no issues. > > No changes have been made to the server. > > Checking the IBM/Informix defects list didn't show anything. > > Any suggestions? > > Thanks, > > Fred Prose > Az Supreme Court