[AccessD] How to Force ODBC Timeout

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.
**********************************************************************



More information about the AccessD mailing list