An error I have not yet seen!

[zarkon4]

I am hoping someone can point me to a solution for an error
I am getting on a pc (NT4.0) and a VB6 App with SQL Server 2000.

The Error:

Run-time error '-2147467259 (80004005)':
Unable to send message to server.SendMessage :Socket is null

It is occurring on the recordset.update method.
To me it sounds as if the tcp connection between the users pc and SQL Server 2000 is getting hosed. If the user goes back into the app and performs the transaction again, all is well and the data is updated. Could there be a timeout issue? Should I be posting this in the SQL forum? I posted it here because VB 6 is being used and the error occurs in a VB 6 App.

Anyone ever seen this error? Any ideas on correcting it?

Thanks,

 

[bmdb]

It may just be a simple Time-Out issue. Try increasing your time-out setting.

 

[zarkon4]

That is what I had thought as well, other pc's that run the app do not experience it, and it has proven to be intermittently. The connection timeout is zero anyway.
We have changed the lock type on the recordset and are awaiting results of that change. It was set as pessimistic and has been changed to optimistic.