Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Question Unanswered: General network error help - timeout issues

    Hello all,

    We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

    This site receives the following error as seen in the topic:
    [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

    We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

    <%
    ' FileName="Connection_ado_conn_string.htm"
    ' Type="ADO"
    ' HTTP="false"
    ' Catalog=""
    ' Schema=""
    MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
    %>

    Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

    The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

    Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

    Should have 330 rows if it works right.
    Last edited by divman; 09-30-04 at 20:37.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    See if this webcast can help you any:

    http://support.microsoft.com/service...4/manifest.xml
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Sep 2009
    Posts
    1

    [DBNETLIB][ConnectionRead (recv()).]General Network Error. Check Your Network Documen

    Quote Originally Posted by divman
    Hello all,

    We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

    This site receives the following error as seen in the topic:
    [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

    We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

    <%
    ' FileName="Connection_ado_conn_string.htm"
    ' Type="ADO"
    ' HTTP="false"
    ' Catalog=""
    ' Schema=""
    MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
    %>

    Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

    The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

    Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

    Should have 330 rows if it works right.
    pls help me on that
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •