Conenct

  • Thread starter Thread starter ehorn
  • Start date Start date
E

ehorn

Hi,

Has anyone figured out how to increase the timeout of on CommandTimeout
in Access 2003?

I have a stored proc that takes about 2 minutes to run and the report
has timed out.

I have tried setting the "connect timeout" property in the connection
properties, and have also tried through code.

Any ideas?

Thanks,
 
If you mean the odbc timeout message then you right click on the grey part of
your query, go to properties, and under odbc timeout, change it to 3000.
That should fix your problem.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timeout executing query including ODBC-linked SQL Servertables 6
SqlCommand.CommandTimeout seems to have no effect 1
BeginTransaction causes command to ignore timeout 1
Access and OBDC connections 1
Timeout expired using the SqlDataSource WebControl, ASP.NET 2.0 1
Increase Connection\ Command timeout globally 7
Report gives "Timeout Expired" all of a sudden 1
DateDiff past Midnight 8

Back
Top