I have an asp script that allows you to delete a customer form a database including all his files. While trying to delete one of the customers from an asp script I get the following error message:
------------------------------------------------------------
Database Errors Occured
Delete From FileDescription WHERE CustId=49
Error #-2147217871
Error desc. -> [Microsoft][ODBC SQL Server Driver]Timeout expired
-----------------------------------------------------------
That particular customer has a lot of files to delete. I have tried it on customers with fewer files and I don't get this error message. I was womdering what I could do so that thw query does not timeout? i.e. so that it completes the deletion process.
Grateful for any help, thanks.
Taha
------------------------------------------------------------
Database Errors Occured
Delete From FileDescription WHERE CustId=49
Error #-2147217871
Error desc. -> [Microsoft][ODBC SQL Server Driver]Timeout expired
-----------------------------------------------------------
That particular customer has a lot of files to delete. I have tried it on customers with fewer files and I don't get this error message. I was womdering what I could do so that thw query does not timeout? i.e. so that it completes the deletion process.
Grateful for any help, thanks.
Taha