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!!