November 16, 2003 at 7:44 am
My clients at remote computers receive
database error code :10005
Database error message:
Select error: DBPROCESS is dead or not enabled.
At the same time SQLServer is working OK.
So I suppose that the problem in time out connection. I set the connection property - Query time-out=0 (unlimited), but it didn't help.
I'll glad to any ideas.
November 17, 2003 at 9:13 am
I had a similar problem last week. If your SQL Server is up and running with no errors, the client issue is most likely due to some kind of network communication problem. Have these clients connected before and now have stopped? If so, you'll need to see if anything like a different version of MDAC or something similar got loaded on them. Can you ping the SQL server or create ODBC connections from the clients?
In my case, I got the error when attempting to resolve an SQL connection using the server name, but did not get it when using the server IP address. Investigation revealed that DNS was not correctly configured on the client therefore it couldn't resolve the host name. Once this was fixed, the application could connect with no problems. I hope this helps you.
My hovercraft is full of eels.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply