Groups | Blog | Home
all groups > sql server connect > november 2006 >

sql server connect : [DBNETLIB]ConnectionWrite (send()) error


mikron2
11/7/2006 4:55:02 PM
I've searched trying to find help for "[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite (send())", but couldn't find any solutions
(and precious few leads). I think I've figured out the problem, and wanted
to post it in case anyone else was looking also.

My enabled protocols in the SQL Server Client Network Utility, Named Pipes
and TCP/IP, were set to where TCP/IP was first in the list. I changed it to
where Named Pipes was at the top of the list, and my query (from my
workstation to the server) now runs instead of getting the error message
shown above.

Does anyone have anything else to add to this that might further clairfy the
issue?

Thanks,

mikron2
11/8/2006 12:29:02 PM
Two lines:

SQL server listening on n.n.n.n: 14yy.
SQL server listening on x.x.x.x: 14yy.

Replaced the actual numbers with n's, x's and y's, of course.

Mike
mikron2
11/8/2006 12:37:02 PM
Sorry, I missed a line:

SQL server listening on TCP, Shared Memory, Named Pipes.

It's after the other two lines I mentioned earlier.

Mike
Kevin3NF
11/8/2006 2:14:02 PM
TCP protocol is failing to connect...is the SQL Server listening on that
protocol? Look in the current SQL Server ERRORLOG for a line similar to:

SQL Server listening on TCP, shared memory, named pipes

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


[quoted text, click to view]

Kevin3NF
11/8/2006 3:28:50 PM
At least we know that its trying to listen

From your client machine, assuming you have Query Analyzer, try to make a
new connection. In the servername box, instead of SERVERNAME use

tcp:SERVERNAME, 1433

if that fails, try:

tcp:x.x.x.x, 14yy (replace x with your external ip, and 14yy with the
correct port)

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


[quoted text, click to view]

AddThis Social Bookmark Button