I have a asp script that allows the user to delete certain customer records, there is a large amount of customer records. When I run a query to delete the customer records I get the following error:
-------------------------------------------
Database Errors Occured
Delete From FileDescription WHERE CustId=49
Error #-2147217871
Error desc. -> [Microsoft][ODBC SQL Server Driver]Timeout expired
-------------------------------------------
I have set the ASP script timeout on the ISS server to 300 seconds but even then I get this message before even getting anywhere near 300 seconds.
Why does this happen? How can I prevent it from happening?
Grateful for any help given
Thanks.
-------------------------------------------
Database Errors Occured
Delete From FileDescription WHERE CustId=49
Error #-2147217871
Error desc. -> [Microsoft][ODBC SQL Server Driver]Timeout expired
-------------------------------------------
I have set the ASP script timeout on the ISS server to 300 seconds but even then I get this message before even getting anywhere near 300 seconds.
Why does this happen? How can I prevent it from happening?
Grateful for any help given
Thanks.