Solved

ConnectionRead (WrapperRead()) Error

Posted on 2004-09-03
11
1,716 Views
Last Modified: 2010-08-05
O/S Win2k Advanced Server
Running SQL Server sp3

Using
MDAC 2,80,1022,3
ADO 2.8
VB 6

For a while now our SQL server has been returning this error:
[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation

It seems that many people have run into this problem but not much in solutions has really been posted (well, at least not one that works for me)

It gets very troublesome since it seems that the database gets locked when this error is generated.  To provide a temporary remedy I have to clear all connections to the database, sometimes more than once.  I have been searching the web for a while and have been trying to find a remedy for this and trying any solution I have found that may provide a solution to this problem.  Turnging connection pooling off (in reference to kb article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564).

This problem isn't happening on all databases either, which makes this even more troublesome.

Everything at the database level seems to be checking out (I've run DBCC checks with no errors being generated in reference to http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21076842.html).  I've tried running performance traces to see if there is a TCP reset that is happening but haven't seen one yet.  It seems that a TCP reset is probably causing the error but I can't seem to find it.  In looking at KB I found the following article: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q154/6/28.asp&NoWebContent=1 and applied this fix hoping that this was the problem causing TCP resets.  The problem was not fixed by this.  The named pipes and TCP settings in the client network utility are fine and the web server recognizes by IP and Name.

Any help would be greatly appreciated.
0
Comment
Question by:poliguin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 3
11 Comments
 
LVL 18

Assisted Solution

by:ShogunWade
ShogunWade earned 200 total points
ID: 11974929
Might be the completely wrong in your case,  but I had a similar error some time ago on a heavily stressed server.   It turned out that the raid controller card was intermittently flaking out and coming back.   Replaced the controller and its been ok since.
0
 
LVL 2

Author Comment

by:poliguin
ID: 11974951
That's worth a shot.  I don't get to control such decisions, etc but I'll see if that works.
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 11975004
check in your system event log and application log for any disk errors.  or if you have something like a PERC controller (which we have) there were a series on events in the raid diagnostic software.

0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 34

Accepted Solution

by:
arbert earned 300 total points
ID: 11975199
Agree with ShogunWade....I've found that when most of these errors have happened it's because of overly HIGH IO on the server....

I really hate this error 'cause it really isn't indicative of what the problem might actually be!
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 11975238
"I really hate this error 'cause it really isn't indicative of what the problem might actually be!"

Me too,  unfortunately I didnt discover what it was in my case untill the controller died completely ;(
0
 
LVL 34

Expert Comment

by:arbert
ID: 11975267
Ouch!  

I don't want to hijack the question, but shogun, why don't you drop me an email sometime--my addy is in my profile....

Brett
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 11975392
will do
0
 
LVL 2

Author Comment

by:poliguin
ID: 11975441
highjack away.  I'm going to have someone look into the Raid controller and see if that's the problem.  If it isn't then I'll try and get the thread back, ha.
0
 
LVL 2

Author Comment

by:poliguin
ID: 12051437
after doing more research and it seems to be pointing to the client connection reseting the connection.  i've come to this conclusion after finally finding a query that i've found to cause the problem from several different locations and have found that when i do it remotely that i end up getting this error back.

it also helped when i finally got enterprise manager to return the error [microsoft][odbc SQL Server Driver]Communication Link Failure.  it's kind of funny that i should be getting a connection timeout error since the offending query i've been running exceeds the connection timeout but instead decides it wants to return this error instead and lock the database up (the connections are getting properly closed within the error handling).

finding where this tcp reset is the part that i have no idea about.  i've been asking the network guy to run checks on the router, switch, etc for the past week or so but he seems to insist that it is highly unlikely anything would ever go wong with them.  being this the case, how do i go about finding out where this reset is coming from?
0
 
LVL 2

Author Comment

by:poliguin
ID: 12068597
it wasn't really the raid controller but rather high io that was causing the server to conk out on an intermittant basis.  it tended to be more intensive querries that were causing this problem most of the time.
0
 
LVL 34

Expert Comment

by:arbert
ID: 12068667
Nice--glad someone else has verified this same problem :)  Just doesn't make sense to me why things are so quick to timeout in these scenarios...
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

742 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