SQL server 2000 Connection Write Send Failure ERROR!!! HELP!!!
Posted on 2007-10-21
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