You will get a timeout when retrieving from large tables if you exceed the
timeout parameter set in the ODBC setup for that driver. You might try
increasing that value.

-----Original Message-----
From: Ruth Gramolini [mailto:[Email Address Removed] Thursday, August 30, 2001 09:40
To: LazyDBA.com Discussion
Subject: ODBC link from Oracle to Access




> Hi all,
>
> We are having a terrible time using and ODBC link to bring down some very
> large tables into ACCESS. Our users want to know why they are
experiencing
> timeouts and other problems. Does anyone have a simple answer to why ODBC
> links to get very large tables is having these problems .
>
> Thanks,
> Ruth B. Gramolini
> ORACLE & DB2 DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> [Email Address Removed] --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: [Email Address Removed] 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: [Email Address Removed] (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).


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page