[AccessD] How to Force ODBC Timeout

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



More information about the AccessD mailing list