Post reply

Run-time error '-2147467259 (80004005)

  • February 7, 2013 at 2:26 pm

    #270510

    Hi,

    I have a client who runs SQL2008 on a 2008 R2 server.

    They run an accounts program and have started getting errors on the client side when running this program.

    The error is as follows.

    "Run-time error '-2147467259 (80004005)

    Fatal error trying to open recordset: [Microsoft] [ODBC SQL SERVER DRIVER] [TCP/IP Sockets] ConnectionWrite (Send())."[/b]

    The software vendor always blames "The network" or "The Server".

    I have tested both the network and the server both of which are absolutely fine. The connection between server and client is gigabit.

    The client PC is windows 7.

    Please somebody shed some light.

    Thanks

    Dan

  • February 7, 2013 at 5:40 pm

    #1585707

    That error number is fairly generic so we have to look at the message.

    The fact that the message refers to TCP/IP and ConnectionWrite indicates network issues.

    Combined with the fact that the application has been working, and these errors have recently started, makes me doubly suspect the network.

    Of course that could be any number of things, from NICs in client or server, through to network switches and even issues with domain controllers causing DNS lookup failures. I hate seeing any network related error as they are so difficult to trace down.

    If you run SELECT @@PACKET_ERRORS on your server, what do you get?

    Also check the error log and the CONNECTIVITY ring buffer. All these will tell you whether or not the connection ever made it to the SQL Server in the first place.


    Check Your SQL Servers Quickly and Easily
    www.sqlcopilot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply