Rusty Hammond
rusty.hammond at cpiqpc.com
Tue Apr 23 17:08:31 CDT 2013
Brad, It may have more to do with with how quickly the data starts getting returned by the ODBC database. Even though your front end query was taking a while, the data is being returned to the front end immediately so that part of the equation isn't timing out. Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, April 23, 2013 4:53 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout Rusty, Good idea. I will try to do this. I am starting to wonder if the ODBC Timeout value at the query level works differently for Pervasive than how it works for SQL Server. Thanks for your help. 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 4:51 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to Force ODBC Timeout Brad, Can you create a view (or query - not sure what pervasive calls it) in the Pervasive database that takes several seconds to run, then in your front end, create a linked table to that view and use this new linked table in your front end test query. Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, April 23, 2013 3: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 ********************************************************************** 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=7939027E05.1530D -- 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. **********************************************************************