[AccessD] Change ODBC timeout default query property

Gary

Which driver do you use? And unclick works?

We are using the ORACLE ODBC driver Ora 9i. But also happens against
FOXPRO. 

I went to the Administrative tools, Data Sources(ODBC) and unclicked
Query Time out. Opened the MDB and tried a pretty simple query without
changing the Query Property Timeout over 60.  It still timed out. 

I get the following message if I don't set the QUERY PROPERTY ODBC
Timeout from 60 up to at least 500. I routinely set it at 6000. 

	ODBC--Call failed. 
	[Oracle] [ODBC] [ORA] ORA-01013: user requested cancel of
current operation (#1013)

I know immediately that I forgot to update the timeout by the message
above. Many others do not understand so I am always checking out their
queries and machines. 

I was wondering whether there was a change to Registry or some hidden MS
change that would fix this.   

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. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Tuesday, August 22, 2006 10:11 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Change ODBC timeout default query property
> 
> 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
> > **************************************************
> > --------------------------------------------------------
> --
> Gary Kjos
> garykjos at gmail.com
> --