Connection String/Network Library

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: James (letyoudown_at_verizon.net)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 09:09:59 -0500

We've had a recurring problem where all of a sudden we get a DBMSSOCN
General Network Error on any page that connects to SQL Server. Then we have
to reboot the server and everything works fine again, for a few more hours
and then we have the same problem. Someone suggested adding ";Network
Library=DBMSSOCN" to our connection strings. I've tried to figure out
exactly what this does and why not having it would be a problem. Any ideas?
Thanks.

Relevant Pages

  • Re: Timing out????
    ... >> UPDATE LookUp ... and means something different to SQL Server. ... >> General network error. ... >> Ralph Krausse ...
    (microsoft.public.sqlserver.programming)
  • Possible Workarounds: "General Network Error" using TCP/IP with .CommandTimeout = 0
    ... Possible Workarounds for some cases of "General Network Error" using TCP/IP ... Looking at the Packet Trace, the failure case generated a packet with ... ACK+RESET bits set (visible from both Client and SQL Server side). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Auto retry synchronization/agent
    ... LoginTimeout parameter and retry the operation. ... General network error. ... (Data source); Error number: 11) ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: DTS Errors
    ... The key bit in there is "General network error". ... Microsoft Data Transformation Services Data Pump ... (Microsoft OLE DB Provider for SQL Server (80004005): ... Step Error code: 8004206A Step Error Help ...
    (microsoft.public.sqlserver.dts)
  • Data Source = problem
    ... I've been having this recurring General Network Error problem and I've been ... Reboot fixes the problem for several hours, ... HTML loads fine, ASP pages that connect to SQL Server, no dice. ...
    (microsoft.public.inetserver.asp.general)