random connection error

  • I have multithreaded, multiple connection environment using SQL2K DB server using TCP/IP network layor, Win2K OS.

    My application is throwing following error at random interval.

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

    Any leads to solve this problem will be helpful.

    Thanks

    Gopal

  • This was removed by the editor as SPAM

  • Looks like a network issue. Do you get the error from multiple machines? If only one machine might be as simple as a bad NIC or bad patch cable. If multiple machines get your network team involved, have them check all switches/routers between the machines and the server.

    Note that this is also a good opportunity to deal with a dropped connection - it will happen sooner or later, better to have your app deal with it gracefully.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Thanks Andy.

    Unfortunately this error is not related to hardware as it happens in various testing environments but randomly. In fact I found on internet lot of people facing this problem but nobody got the solution.

    One of our newly created application we handled dropped connection properly and this error is taken care (Not solved).

    Thanks for your time.

    Gopal

  • A long time ago I had the same problem.

    This problem disappeard completely when the network cabling was replaced.

    So, I think it is a hardware or network congestion problem.

Viewing 5 posts - 1 through 4 (of 4 total)

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