Timeout expired in sql server problem
- by Avinash
set con2=server.CreateObject("ADODB.Connection")
con2.ConnectionTimeout =1200
con2.open "Driver={SQL Server};server=111.111.111.11;user id=xx;pwd=xxx;Database=xxx"
con2.execute("DELETE FROM tablename WHERE fieldid NOT IN(SELECT fieldid FROM tablename2)")
con2.close
set con2=nothing
when i running this query using asp the following error occured. How to solve this issue?
Microsoft OLE DB Provider for ODBC
Drivers error '80040e31'
[Microsoft][ODBC SQL Server
Driver]Timeout expired