SQL SERVER NOT UPDATING RECORDSET

[janpetrucci]

I am having a very unusual problem with SQL Server 2000. Maybe someone can help me with this.

I am running an ASP site. The server is Windows NT 4.

I was using Access as the database and just upgraded to SQL Server 2000. When I had 2000 records in the SQL table, my asp page updated the records perfectly.

When I added 10000 more records to the table I now get Script timeout messages and the page is halting on the Update statements.

strSQL = "UPDATE Orders SET ReceivedDate = '" & strNO6 & "' WHERE GenOrder = '" & strNO & "'"
objCmd.ActiveConnection = strConnect
objCmd.CommandType = adCmdText
objCmd.CommandText = strSQL
objCmd.Execute , ,adCmdText

The strange thing is that the page works with 12000 records in the Access table...it runs well and updates the recordsets pretty quickly. I thought SQL server would be faster.

I thought maybe I was getting locked on a record, so it would not update, but I am closing the recordsets and I get the same results.

The problem seems to happen on records that I have recently updated in the larger table. It doesn't happen at all in the smaller table.

Has any one had a problem like this???

 

[jhall156]

Sounds like your query times out. Check the querytimeout in your connection. Probably defaults to 15 seconds or something. There's also a connectiontimeout but I think it defaults to either a big value of indefinite. JHall

 

[fluteplr]

See answer to your other post. Really, once is enough. Also TURN OFF YOUR CAPS KEY. It is hard to read and looks like you are shouting.