Gary Kjos
garykjos at gmail.com
Tue Aug 22 09:10:49 CDT 2006
Which ODBC driver are you using? With the Oracle ODBC Driver for Oracle you can tell it to just NOT timeout by unchecking the Timeout checkbox. On 8/22/06, O'Connor, Patricia (OTDA) <Patricia.O'Connor at otda.state.ny.us> wrote: > Hi all > > Is there a way to set the ODBC timeout default in the query properties > from 60 to 6000 permanently? Most of our work is against our ORACLE > databases, some Foxpro, and SqlServer. For every new query we do we have > to remember to reset this before running otherwise we get a timeout. > Does not matter how easy or hard the query is, If it isn't at least 600 > then poof it stops. One person said that it would cause their MDB to > corrupt but I haven't had that problem. > > The OPTIONS ADVANCED does not do this. I have looked almost everywhere > but can't find out how to change the default. This would be for 2k or > 2k3. > Any help appreciated > > Thanks > > ************************************************** > * Patricia O'Connor > * Associate Computer Programmer Analyst > * OTDA - BDMA > * (W) mailto:Patricia.O'Connor at otda.state.ny.us > * (w) mailto:aa1160 at nysemail.state.ny.us > ************************************************** > -------------------------------------------------------- > This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com