RE: OT - ODBC Timeout?

From: Post, Ethan <epost_at_kcc.com>
Date: Wed, 08 Aug 2001 10:11:08 -0700
Message-ID: <F001.0036494C.20010808100646@fatcity.com>

You can set the ODBC timeout property on two places. If you are using a pass through query in access pull up the properties and you will see a timeout setting. Setting to zero means infinite else seconds. The newer Oracle ODBC drivers also allow you to configure a timeout setting via ODBC manager in control panel. Just pull up the properties for the ODBC connection you are using. If you need to adjust the timeout settings for a query executed against a link table (not sure if this is possible) you might need to attach to the table using VBA and perhaps you will have access to the setting.

Ethan
http://www.geocities.com/epost1

>-----Original Message-----
>From: Speaks, Chuck W. [mailto:CSpeaks_at_Lithonia.com]
>Sent: Wednesday, August 08, 2001 8:52 AM
>To: Multiple recipients of list ORACLE-L
>Subject: OT - ODBC Timeout?
>
>
>Sorry for the OT. Does anyone know if ODBC has a timeout
>setting? I have a
>developer using ODBC to access a database through a custom
>app. After a
>couple of minutes of churning on the call, we get the ODBC-call failed
>error. However, using the same ODBC driver in Access, I'm
>able to access
>the database without any problems.
>
>Any information would be appreciated. Thanks.
>
>Chuck Speaks
>Database Administrator
>Lithonia Lighting
>770-860-3450
>http://www.lithonia.com
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Speaks, Chuck W.
> INET: CSpeaks_at_Lithonia.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: epost_at_kcc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Aug 08 2001 - 12:11:08 CDT