I have some W2K workstations receiving this error after a few minutes of using an mssql network based application.

DBNETLIB -2147467259

The SQL Server is a Microsoft SBS 2003 server. Very light duty.

Running "netstat -na" on the clients shows a whole lot of tcp ip ports in TIME_WAIT mode. I strongly suspect that the clients are running out of ports to use. Note: TCPIP ports are NOT directly interrelated with connection pooling in the ODBC driver -- I've lost the web reference to this, though.

On clients tried this as a work around to the problem:
http://support.microsoft.com/kb/319502/EN-US/


This hasn't solved the problem.

This thread about intermittent "General Network Error" might be useful -- at the very least it offers some ideas on how to monitor for MDAC and other errors:

http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_thread/thread/87735b6e69943e0c/cde0b0ef9cfaab9a?lnk=st&q=dbnetlib+%22general+network+error%22+intermittent&rnum=2#cde0b0ef9cfaab9a

The thread mentions this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;191168

Related Scribbles:

TCP/IP Ports Lists

Registry Tools

SQL Server

---

ID: 657
Author:
leonard
Date Updated:
2006-01-23 22:54:01
Date Created:
2005-07-08 23:40:07

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> DBNETLIB -2147467259

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.