SQL Timeout

[Lin Ma]

Dear all,

I need run a few large queries for one time only. But I get scripttimeout.
So I set up server.ScriptTimeout value. It works fine.

But for one query, system gives me the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E31)
Timeout expired

No matter how much I increase ScriptTimeout value, I still have the same
error.

Is there a setting for SQL server timeout value?

Thanks,

Lin Ma

 

[Richard K Bethell]

Script timeout value has no effect on SQL timeout. You have to change the
value of your ADODB.Connection's CommandTimeout property to something long
enough to allow your SQL server to do the work.

R.