Jim Lawrence
accessd at shaw.ca
Wed Apr 24 09:22:53 CDT 2013
Hi Brad: One more suggestion would be to use a OLEDB style connection other than a ODBC type. This way you will have better control, allows simple access to all errors, even multiple errors and much improved connection performance results. OBDC embeds the OLE call which traditionally performs much slower, with less control or easy access to results. Check out the following for a start samples: http://www.connectionstrings.com/pervasive#pervasive-ole-db-provider Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, April 23, 2013 1:15 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout Rusty, Thanks for your help. I am trying to force an ODBC timeout in order to test some new error handling code. I have set the ODBC timeout to 1 second on one of the queries. When I run this query, it takes several seconds to retrieve the data, but there is no ODBC time out error issued. If I open the linked table, it starts to show data immediately. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Tuesday, April 23, 2013 2:16 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout Does your query have multiple linked tables that it's querying together? Could be the data is coming back quickly from the pervasive table, but the work in relating the data in the multiple tables is what's taking the time. What happens when you simply open the linked table in the front end, does it start showing data immediately? Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, April 22, 2013 3:58 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout Rusty, The data is coming from a Pervasive Database (Purchased Accounting System) via a Linked Table. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Monday, April 22, 2013 3:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout I have to ask, is the recordsource of the query an ODBC based data source (ie a Linked table referencing a SQL database table) or is it just an Access table? Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, April 22, 2013 3:22 PM To: Access Developers discussion and problem solving Subject: [AccessD] How to Force ODBC Timeout All, I would like to test the error handling of ODBC Timeout errors. I set a test query's ODBC Timeout to 5 seconds. When I open the query from VBA code, it takes about 40 seconds to open. There is no ODBC Timeout error generated, however. I must be missing something. Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=78D7D27E17.44D8F -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=7AD9E27E14.9AC8A -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com