none
odbc error RRS feed

  • Question

  • one of our clients is trying to connect to our sql server 2000 database from one of our apps and is getting an odbc error:

    2009-03-31 16:18:07.971 ******************** ODBC Errors ********************
    2009-03-31 16:18:07.971 Return code = -1.
    2009-03-31 16:18:07.971 SQLError[00] SQLState    '08S01'
    2009-03-31 16:18:07.971 SQLError[00] NativeError 11
    2009-03-31 16:18:07.987 SQLError[00] Message     '[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.'
    2009-03-31 16:18:07.987 SQLError[01] SQLState    '01000'
    2009-03-31 16:18:07.987 SQLError[01] NativeError 10054
    2009-03-31 16:18:07.987 SQLError[01] Message     '[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).'
    2009-03-31 16:18:07.987 ******************** ODBC Errors ********************

    We have lots of other clients and they are not having this problem

    Any ideas?
    Saturday, April 4, 2009 4:39 AM

Answers

  • To be more specific, Native error 10054 is Winsock error "Connection Reset by Peer", ConnectionRead (recv()) means that the TCP connection was terminated on server when the client was reading data from the socket.

    1. Was server restarted when there are exisiting connection to it.
    2. Check SQL error log to see there was any exception thrown around the time when the client received the error, an exception in sql results in the corresponding connection being dropped.
    3. If this happened intermittently, sometime the error could indicate network hardware issue. You should involve your network admin to trouble shoot using netmon etc.

    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, April 7, 2009 6:18 AM
    Moderator

All replies

  • This indicates network problems. Ask your LAN administrators to check all network equipment between the machines involved.
    Saturday, April 4, 2009 7:21 AM
    Answerer
  • To be more specific, Native error 10054 is Winsock error "Connection Reset by Peer", ConnectionRead (recv()) means that the TCP connection was terminated on server when the client was reading data from the socket.

    1. Was server restarted when there are exisiting connection to it.
    2. Check SQL error log to see there was any exception thrown around the time when the client received the error, an exception in sql results in the corresponding connection being dropped.
    3. If this happened intermittently, sometime the error could indicate network hardware issue. You should involve your network admin to trouble shoot using netmon etc.

    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, April 7, 2009 6:18 AM
    Moderator