Re: detecting a dead connection

From: Brannon Jones (brannonjNOSPAM_at_gmail.com)
Date: 09/17/04

  • Next message: serge: "Re: How does ODBC's authentication work?" 
    Date: Fri, 17 Sep 2004 12:13:10 -0700

    I'm curious what problem you've heard exists with SQL_ATTR_CONNECTION_DEAD?

    Why do you need to test whether or not the connection is dead? Just try to
    use it and have the correct error handling in place.

    What happens if you successfully test that the connection is alive, and then
    it dies a second later? You have to handle that error case anyway, so why
    worry about testing to see if it's dead or not?

    Brannon

    "Gideon" <grashkes@yahoo.com> wrote in message
    news:fb0829e1.0409170355.70ffd16b@posting.google.com...
    > Hi all -
    > I need a way to detect a dead connection.
    > I realize there has been a problem with SQL_ATTR_CONNECTION_DEAD , so
    > I use
    > SQLGetConnectAttr with SQL_COPT_SS_CONNECTION_DEAD instead.
    > I still dont get the expected result.
    > (btw, SQL_COPT_SS_CONNECTION_DEAD is defined as
    > SQL_ATTR_CONNECTION_DEAD. What kind of a fix is that?)
    >
    > Any help appreciated,
    > Gideon.

  • Next message: serge: "Re: How does ODBC's authentication work?"

    Relevant Pages

    • GI Dimming - RESOLVED
      ... screwy or dead on all strings and both cases it was the LM339. ... Swapped a TRIAC out with a known good one off a working board (just 1 ... connection. ... replacing the connector, just did the 'continuity checks' recommended ...
      (rec.games.pinball)
    • Re: Cannot establish a connection.. yet again
      ... "Martin Dabkiewicz" wrote: ... I'm dead in the water. ... >> but connection error stops its getting to the PPC ... >> I think I'm missing some trivial thing. ...
      (microsoft.public.pocketpc.developer)
    • Re: OT: Son of a beotch Win XP...again
      ... Fire up the PC tonight...no connection. ... Did the repair function, ran ... Network card dead? ...
      (alt.guitar)
    • Re: detecting a dead connection
      ... I need to use it to find out whether the connection is alive or not ... Using SQLGetConnectAttr with 'SQL_COPT_SS_CONNECTION_DEAD' on a dead ... SQL Server connection I can ...
      (microsoft.public.sqlserver.odbc)