When a connection disconnects?

  • When does SQL Server decide to disconnect a current session and start a new one? We are having an ongoing problem with this. The symptoms are much like the bug reported in Q191268 at ms-help://MS.VSCC/MS.MSDNVS/kboledb/Source/oledb/q191268.htm. I have gone through the code and closed all known open cursors, and we are still having the same problem. So I'm taking a step back, wondering why we a connections are disconnected.

    Steve



    Steve Miller

  • Can you give details of your situation? WHat type of app, what is happening, when does it happen?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • >> WHat type of app

    C++ front end, SQL Server on the back.

    >> what is happening

    Well the symptoms are much like the bug reported in Q191268 at ms-help://MS.VSCC/MS.MSDNVS/kboledb/Source/oledb/q191268.htm.

    It's the same problem I've been fighting at http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=6880.

    >> when does it happen?

    That's what I'm trying to find out.

    Steve



    Steve Miller

  • The problem was in the C++ code! Ha!

    Steve



    Steve Miller

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

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