General discussion

Locked

SQL ODBC timeout in RunSQL

By john_wills ·
I have in an Access database a query object reading from a remote database via ODBC. It takes a while, but it works. To let the user set criteria I have the same query in VBA executed from a form via DoCmd.RunSQL. I get an ODBC Timeout message. I know how to change the timeout value in a query object, but not in a text query within VBA. How can I set my timeout value, and is there anything else I can do?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL ODBC timeout in RunSQL

by Steve.Simons In reply to SQL ODBC timeout in RunSQ ...

Although I could spend a couple of hours writing out an answer for you, look at this MS KB article. I think it answers your question pointedly enough to where you can head off in the right direction.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q138066&ID=138066

Good Luck!

Q138066 - HOWTO: Handle OLE Automation Server Timeout and Synchronization
There are seven properties of the App object that allow you to handle the timing and synchronization of OLE calls made from a Visual Basic client to an OLE automation server:

Collapse -

SQL ODBC timeout in RunSQL

by john_wills In reply to SQL ODBC timeout in RunSQ ...

You seem to have given me the wrong url.

Collapse -

SQL ODBC timeout in RunSQL

by Steve.Simons In reply to SQL ODBC timeout in RunSQ ...

My bad. I just cut and pasted. Try this one.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q138066

Collapse -

SQL ODBC timeout in RunSQL

by Steve.Simons In reply to SQL ODBC timeout in RunSQ ...

Well, it doesn't like the cut and paste thing.
I'll type it out for you......

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q138066

Try that.....

Collapse -

SQL ODBC timeout in RunSQL

by Steve.Simons In reply to SQL ODBC timeout in RunSQ ...

Cut and paste the URL and remove the space that keeps somehow being put between the "; and the Q138066. That worked for me. If not, just search for the Knowledge Base article Q138066.

Collapse -

SQL ODBC timeout in RunSQL

by john_wills In reply to SQL ODBC timeout in RunSQ ...

Essentially the note says that I may have been impatient. I can repeat the error by doing nothing for the 90-odd seconds the database takes to get there, so that is not the problem.

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums