We help IT Professionals succeed at work.

ADO/SQL Server 2000 - timeout expired on recordset update

AndrewAitken
AndrewAitken asked
on
1,883 Views
Last Modified: 2007-12-19
Hello,

I am using ADO connecting to SQL server.  
I open a recordset and then insert a record using .AddNew and .Update
When the .update line of code executes, I am get a timeout expired error. (-2147467259 (80004005))

I've played with timeout settings on the server and with the ADO connection, but they didn't seem to help.

The table that the record is being inserted into has 62000 records.

Another important note is that there is an insert/update trigger on the table that creates a cursor which goes through the inserted records and updates one of the fields to be the concatenation of several other fields.

Any help figuring out why this time out error is happening would be much appreciated!!


Andrew
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank-you for the suggestions.

There are several indexes on the table (PK, and others).  I created a new index on two fields together and now I no longer get the time out issue.

I will split the points since my solution was different that what was suggested.

Thanks again,


Andrew
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.