[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL server 2000 Connection Write Send Failure ERROR!!! HELP!!!

Posted on 2007-10-21
7
Medium Priority
?
292 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:JackOfPH
  • 4
  • 3
7 Comments
 
LVL 14

Expert Comment

by:twoboats
ID: 20121725
Is there anything in the sql server error log pertaining to this?

It might be deadlocking.
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 20128220
what is deadlocking?
0
 
LVL 14

Expert Comment

by:twoboats
ID: 20130074
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).
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Author Comment

by:JackOfPH
ID: 20135686
How can I fix this?
0
 
LVL 14

Expert Comment

by:twoboats
ID: 20137085
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?
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 20160728
All write transaction is not accepted. There is no message in the log file.
0
 
LVL 14

Accepted Solution

by:
twoboats earned 1500 total points
ID: 20168255
Try connecting as the affected login using query analyser and seeing if you can perform "writes"
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question