Informix

nested-group-icon.png

DB2

Expand all | Collapse all

ODBC Driver - Keep Alive

  • 1.  ODBC Driver - Keep Alive

    Posted Mon October 26, 2020 09:27 PM

    Hello everyone,

     

    There is still no keep alive setting on the *client side* of Informix ODBC connections (i.e. driver or registry setting) is there?

     

    Thank you,

     

    Hal Maner

    M Systems International, Inc.

    www.msystemsintl.com

     



  • 2.  RE: ODBC Driver - Keep Alive

    Posted 30 days ago
    There is no CSDK/ODBC "keep alive" option which could be set as part of connection string or registry or environment variable. Since this is related to TCP connection, it could be only set in the SQLHOSTS file as "k=1" in the options field. More info I found in the IIUG link below.

    International Informix Users Group
    Iiug remove preview
    International Informix Users Group
    IDS Forum Re: keep-alive in sqlhosts Posted By: Fernando Nunes Date: Tuesday, 5 September 2017, at 11:16 a.m.In Response To: keep-alive in sqlhosts (Habichtsberg, Reinhard) It will solve the issue (unless the firewall is configured to ignore it, but I've never seen any case of that).HOWEVER...
    View this on Iiug >


    ------------------------------
    Sheshnarayan Agrawal
    ------------------------------