Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-21 : 22:22:17
|
Duayne writes "OK, Mr. Guru I have a real problem on my hands... let me try to explain the situation.
1. I am working with two different machines, both are running Win NT 4.0 and Service Pack 4
2. The webserver is running IIS 5.0, and the other is running MS SQL Server 7
3. The ASP scripts that update and delete appear to work fine on "new" records... but on records that have been there for more than 24 hrs I get timeout errors like the one below.
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/admin/write.asp, line 129
4. the script that I am using to update is below (the delete script is similar).
To update:
Set ObjConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=" & dsn
objConn.Open
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open dbprefix & "disease", objConn, , adLockOptimistic, adCmdTable
objRS.MoveFirst
'Try to find the record in the table
Do Until objRS.EOF OR recordFound
If (StrComp(keys,objRS("keys"),vbTextCompare) = 0) Then
recordFound = True
Else
objRS.MoveNext
End If
Loop
'If the record is not found, then leave without doing anything
If Not recordFound Then
objRS.CancelUpdate
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
Response.Write "Error: record not found."
Response.End
End If
objRS("omim") = Request("omim")
objRS("omimlink") = Request("omimlink")
objRS.Update
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
Any ideas on why this is happening and how I can correct this problem?
Thanks...
Duayne" |
|
|
|
|
|
Getting a timeout error, from an ASP script updating an SQL Server table