I have a 17GB database in the SQL Server.
I have a stored procedure
After I put all the parameters and tried to run the output page.
I got the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/reference/list.asp, line 42
line 42 is the "cmdcp.Execute"
I am using SQL Server 7
the version of the SQL service pack is 3.700..
ODBC Connection was ok after verified.
the store procedure was ok when I run it from the SQL Server and it returns the result.
But when I run it from the web. It gave me the timeout expired.
I am thinking about the client side has the timeout problem. I monitor the SQL Server when I run that page, after I got the timeout message, the SQL Server was still executing the query.
Is that a possible way to set a timeout variable? If so, Where ?
Will it be in global.asa??