RE: Error 10054: [DBNETLIB]ConnectionRead/ConnectionWrite

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 09/10/04

  • Next message: Kevin McDonnell [MSFT]: "RE: Trusted_Connection=Yes vs Integrated Security=SSPI" 
    Date: Fri, 10 Sep 2004 17:26:50 GMT

    Right. You trace indicates that we're unable to write data back to the
    server.

    pfwin 55c-558 ENTER SQLExecDirect
                    HSTMT 066FA478
                    UCHAR * 0x0DADA5F8 [ -3] "DELETE FROM
    PTWinTran
    s WHERE ((fileid = '06006537ECC') AND ((rectype = 2) OR (rectype = 3)))\ 0"
                    SDWORD -3

    pfwin 55c-558 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
                    HSTMT 066FA478
                    UCHAR * 0x0DADA5F8 [ -3] "DELETE FROM
    PTWinTran
    s WHERE ((fileid = '06006537ECC') AND ((rectype = 2) OR (rectype = 3)))\ 0"
                    SDWORD -3

                    DIAG [01000] [Microsoft][ODBC SQL Server Driver][TCP/IP
    Sockets]
    ConnectionWrite (send()). (10054)

    This error 10054, means that the client connection reset the connection
    more than likely. A network trace on the client side would confirm this.

    If you were to execute the same statement from ISQL.exe would the statement
    complete?
    (ISQL.exe) uses dblibrary and doesn't go thru ODBC.

    Since the problem only happens remotely, I would doublecheck the routers
    and switches in between.
    Check all the duplex settings.
    This can cause intermittant failures.

    See Cisco's document:
    http://www.cisco.com/en/US/tech/tk389/tk214/technologies_tech_note09186a0080
    094781.shtml

    Configuring and Troubleshooting Ethernet 10/100/1000Mb Half/Full Duplex
    Auto-Negotiation

    Thanks,

    Kevin McDonnell
    Microsoft Corporation

    This posting is provided AS IS with no warranties, and confers no rights.

  • Next message: Kevin McDonnell [MSFT]: "RE: Trusted_Connection=Yes vs Integrated Security=SSPI"

    Relevant Pages

    • Re: Repost - Unable to authenticate a VPN
      ... a network trace of the machine attempting to make the VPN connection using ... the connection manager client.. ... On the client from a command prompt ... >> Microsoft Small Business Server Support ...
      (microsoft.public.windows.server.sbs)
    • Re: Cache Issues
      ... I ended up putting trace stuff everywhere and found the offending statement: ... I was opening a connection to the database independent of getting the data ... loaded from the DB and not from the cache. ... > finished retrieving data from the cache.... ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Server Does Not Exist or Access Denied error
      ... Server service pack installed and the one that I cannot connect to from my ... the connection is opened with no problem. ... > service packs are installed on each of the remote servers as I am not sure ... >> When I click Test Connection button, the trace indicates a successful ...
      (microsoft.public.sqlserver.connect)
    • RE: Connection Reset Error with SQLState() = 08S01
      ... This sounds like what would be called a general network error (GNE) in the non-JDBC world. ... Most GNEs can be traced down to a piece of hardware inappropriately resetting a connection. ... Here's the full stack trace. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Repost - Unable to authenticate a VPN
      ... Thanks I did get the trace.. ... Microsoft Small Business Server Support ... >> the connection manager client.. ...
      (microsoft.public.windows.server.sbs)