Timeout Expires, even when timeout is 3600 1

[BB101]

I am having some real problems with MSSQL2K and ASP (VBScript).


I have the following connection string:
oCon.Open "Provider=SQLOLEDB;Server=" & Session("ServName&quot & ";Database=" & Session("DbName&quot & ";User ID=" & Session("UserName&quot & ";Password=" & Session("UserPwd&quot & "; Connect Timeout=3600"

However, a few seconds into the script execution, it timesout with the error:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/ipc_dev/CloseRevisionAction.asp, line 79

The ASP has a timeout value of 3600, and so does the connection. I know the stored procedure runs fine, and it does take a while (copy databases, large scale updates etc).

Does anyone know how I can stop this annoyance? --BB

 

[AWithers]

The way I solved this was using the following code in my asp script relating to the command object

set objcommand = server.createobject("adodb.command&quot
objcommand.commandtimeout=0'############## this ensures no timeout as the sp takes a minute or so to run
objcommand.activeconnection = dbconnection
objcommand.CommandText = "sp_yourspname"
objcommand.CommandType = adCmdStoredProc

HTH

Andy

 

[BB101]

Thanks, that what I needed --BB