SQL server 2000 Connection Write Send Failure ERROR!!! HELP!!!
i have an SQL server 2000 database, andlately receiving connection timeout error. I am using an ADO 2.8 object on Visual Basic 6.0 enterprise edition.
Upon investigation we have performed, the error came from a command object when performing Write command on database. Thus raising a connection timeout error.
We detached the database and restore it afterwards. After this, the application can execute Write command again on database. But upon checking on error log file of the application, there are some instance where Write command on database fails.
The user role we use on database has an administrator rights and database was set to public property.
What might be causing this problem on my database lately? Have anyone encountered the same problem? What actions do you perform?
Any insights would greatly help.tnx
Upon investigation we have performed, the error came from a command object when performing Write command on database. Thus raising a connection timeout error.
We detached the database and restore it afterwards. After this, the application can execute Write command again on database. But upon checking on error log file of the application, there are some instance where Write command on database fails.
The user role we use on database has an administrator rights and database was set to public property.
What might be causing this problem on my database lately? Have anyone encountered the same problem? What actions do you perform?
Any insights would greatly help.tnx
ASKER
what is deadlocking?
When 2 or more processes compete to lock the same resource. If a deadlock occurs, SQL server will select a process to kill off to break the deadlock (which will be recorded in the sql server log).
ASKER
How can I fix this?
The first thing to check is whether it's happening. Is there a message in the sql log that says something about a process being selected as a deadlock victim?
ASKER
All write transaction is not accepted. There is no message in the log file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It might be deadlocking.