CommandTimeOut in .adp

[Guest]

Please help me out with this!
I am connecting to SQL Server 2005 through .adp project connection.
For some reason I cannot increase CommandTimeOut property, it is always set
to 30 seconds.

See
http://groups.google.ru/group/micro...+Currentproject&rnum=1&hl=ru#06065379730c5dbe
for same kind of problem.

Thanks,
Ville

 

[Sylvain Lafontaine]

Maybe you have set the wrong timeout.

Make sure that you have set the right timeout.

There are three timeouts in ADP; the first two are located in the advanced
tab on the connection window: Connection menu: File --> Connection -->
Advanced tab for the « Connection TimeOut » and the All tab for the «
General Timeout ».

The third one is the « OLE/DDE TimeOut » in the Options dialog window, you
can try to set it to 0 and close/reopen Access when changing its value;
however I don't expect it to be usefull in your situation.

(There is also a fourth one: the « Command time-out » but this one is only
used when you are creating your own recordsets by using the OLEDB collection
of ADO objects. You should not be concerned with this one unless you are
creating your own recordsets as the sources of your reports. It may be
possible to set this value in the connection string by using the Extended
Properties in the All tab of the connection menu but I never tried this
myself.)

In your case, you should try setting the General Timeout to 0. However,
redesigning your schema and making sure that SQL statements and the stored
procedures used as the sources of your forms and reports are well optimized
and that you have all the required indexes might be a good idea.

You should try these record sources in SQL Query Analyser to see how much
time it takes and, most important, take a look at the generated query plan.
If your queries are not optimized then it's possible that you will be able
to greatly reduce their execution times. See m.p.sqlserver.server and
m.p.sqlserver.programming for more infos.