Timeout expired

[Struck]

I've been running a few queries using the ADO utilities, and after about 30 seconds my query times out with the following message:

ADO ERROR: Microsoft OLE DB Provider for ODBC Drivers exception 80040E31 [Microsoft][ODBC SQL Server Driver]Timeout expired

I figure this must be a setting of some sort, but I can't seem to locate where this setting is created.

Any ideas how to get around this?

Mark

[Tech Support]

There is a xCommandTimeout property on the 'ADODB.Command' object. See if increasing it from the default setting (30 seconds) solves your problem.

[Davin Church]

John's quite right about this, assuming that your query really is one that's supposed to be taking that long. (Otherwise you might look for a problem with your query.)

In addition, if you have a recent version of my code (which might possibly not be on-line yet), I have a way to set a default for that for all such commands. Instead of going to the ADOCommand object to set the CommandTimeout property, look for the same property name on the ADOConnect (connection) object, normally 'ADODB'. If you set it there once then it will automatically be applied to all ADOCommand objects that are created on that connection.