Timeout expired

[leoiser]

My ASP page is calling a Stored Procedure,it will take around 70 to 100 seconds to execute.I am getting timeout error in my ASP page.

I already put
Server.ScriptTimeout = 3600

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

Please Advice....

Thanks

[ilearneditonline]

My ASP page is calling a Stored Procedure,it will take around 70 to 100 seconds to execute.I am getting timeout error in my ASP page.

I already put
Server.ScriptTimeout = 3600

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

Please Advice....

Thanks

The problem is that the connection to the SQL server is timing out, not the script. You need to define a timeout on your command or maybe your connection.

Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Your ConnectionString"
conn.ConnectionTimeout = 120 'number of seconds

Or if you are using a command object

Dim cmd
Set cmd = Server.CreateObject("ADODB.Command")
cmd.CommandTimeout = 120 ' number of seconds

[CalBob]

My ASP page is calling a Stored Procedure,it will take around 70 to 100 seconds to execute.I am getting timeout error in my ASP page.

I already put
Server.ScriptTimeout = 3600

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

Please Advice....

Thanks

In calling your stored procedure set the CommandTimeout = (and the number of seconds you need such as 120)

[jhardman]

Although I have on occasion timed out on long procedures (emailing in particular) I am much more likely to time out when a loop isn't advancing. I have noticed that this happens in even fairly well-formed code when an error causes the loop to not advance but I have included an error handler which keeps the script executing. I don't know if this will help...

Jared

[ilearneditonline]

In calling your stored procedure set the CommandTimeout = (and the number of seconds you need such as 120)

server.scripttimeout has no effect on the stored procedure. that is how long before a script on the page times out. If you have a stored procedure you know takes 70-100 seconds to timeout, you need to make sure that your command object to the database doesn't timeout before the sp can finish.