Timeout expired-Error

In ASP

[rpshah1208]

Hi,
I got an error when i apply update query in an asp page.
In that query only two fields i m going to update.

But that give me this error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/ereport/ReportPageEight.asp, line 48

So, pls tell me solution if you know.

[ctudorprice]

sounds like your sqlserver is not responding... have you tried performing the query outside your asp page, using Query Analyzer or similar? Could be that your query is more complicated than you think and is actually taking longer than your querytimeout settings (check your ODBC connection string and increase this if you think this might be the cause).

[mrMister]

Yes, I'd check the connection string as your first step. Make sure the IP address of the remote SQL server is correct and your machine is capable of connecting to it (try pinging the SQL server from your ASP server)