Professional Web Applications Themes

[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. - ASP Database

Hi, I've got a web app that has a reasonably small database. I've got a stored proc which returns around 7 recordsets, and everything works fine. Problem I've got - on ONE SINGLE RECORD every time I access it through an ASP page, I get the error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network doentation. If I run the SP manually through Query yzer for that line, it runs fine. The line it dies on is: SET rs = rs.NextRecordset My connection string is: Provider=SQLOLEDB;Server=192.168.0.100;User ID=MyUser;Password=MyPass As per a MS knowledge ...

  1. #1

    Default [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

    Hi,

    I've got a web app that has a reasonably small database. I've got a stored
    proc which returns around 7 recordsets, and everything works fine. Problem
    I've got - on ONE SINGLE RECORD every time I access it through an ASP page,
    I get the error:

    Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your
    network doentation.

    If I run the SP manually through Query yzer for that line, it runs fine.

    The line it dies on is:
    SET rs = rs.NextRecordset

    My connection string is:
    Provider=SQLOLEDB;Server=192.168.0.100;User ID=MyUser;Password=MyPass

    As per a MS knowledge base, I've tried adding:
    OLE DB Services= -2

    Still get the same error on the same record.

    Has anyone experienced and fixed this - or something similar - before?

    Thanks in advance,

    Dunc


    Dunc Guest

  2. #2

    Default Re: [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

    http://www.aspfaq.com/show.asp?id=2009

    Dunc wrote:
     

    joker Guest

  3. #3

    Default Re: [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

    Dunc wrote: 

    Does your stored procedure have SET NOCOUNT ON in it? It should.

    Bob Barrows

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

  4. #4

    Default Re: [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

    Uhh... Not sure what I'm looking at - the page doesn't actually contain the
    error I've got...?

    Dunc

    "joker" <com> wrote in message
    news:#phx.gbl... [/ref]
    stored [/ref]
    Problem [/ref]
    page, [/ref]
    your [/ref]
    fine. 
    >[/ref]


    Dunc Guest

  5. #5

    Default Re: [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

    Try this part of the page. At least to me it looks like your error.

    Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBMSSOCN] General network error. Check your network doentation.

    or

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] General network
    error. Check your network doentation.

    or

    Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBNETLIB][ConnectionOpen (PreLoginHandshake()).] General network error.

    This is often a firewall / router issue. Test that your web server can
    ping the SQL Server (both by name and IP) and make sure that your
    connection string points to a valid IP address or network name.

    Of course I could be reading it wrong so I'm not 100% sure. I saw the
    "Microsoft OLE DB Provider for SQL Server error '80004005'" Error & thus
    since that article if for database related issues for that error number
    I thought it might help you out.

    Dunc wrote:
     [/ref]
    >
    > stored
    > [/ref]
    >
    > Problem
    > [/ref]
    >
    > page,
    > [/ref]
    >
    > your
    > [/ref]
    >
    > fine.

    >>[/ref]
    >
    >[/ref]

    joker Guest

Similar Threads

  1. Replies: 3
    Last Post: October 11th, 06:16 PM
  2. #35793 [Com]: General error: 2050
    By andiesPostfach at web dot de in forum PHP Bugs
    Replies: 6
    Last Post: October 21st, 06:20 AM
  3. Replies: 1
    Last Post: November 5th, 10:08 PM
  4. RealPlayer : General Error
    By mjt in forum Linux Setup, Configuration & Administration
    Replies: 2
    Last Post: September 23rd, 12:52 AM
  5. IIS 5 - General error Unable to open registry key
    By Robert Blakeman in forum ASP Database
    Replies: 1
    Last Post: August 1st, 05:57 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139