[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1291.0. "QUERY or CONNECTION Timeouts ?" by M5::DDAYBERR () Mon Jan 27 1997 20:42

       Does ODBC 2.10.11 support query or connection timeouts.  The
    customer is aware of the lock timeout attribute, but is specifically
    interested in QUERY  and/or  CONNECTION timeouts.  Does ODBC support
    this ?    Thanks.
    
    
                                           Debbie
T.RTitleUserPersonal
Name
DateLines
1291.1M5::JBALOGHTue Jan 28 1997 12:006
    I don't believe so. Some front ends such as Access actually issue a
    disconnect when a session is idle for an extended period.
    
    Unless there is something new in 7.0 I don't know about :)
    
    John
1291.2Idle User Timeout in 7.0SQLSRV::MAVRISSue Mavris - smavris@us.oracle.comTue Jan 28 1997 13:228
7.0 adds an idle user timeout.  If no new request comes from the client in 
this amount of time, the dispatcher (the component that does the network 
communication in SQL/Services 7.0) will disconnect the client.

Note - this won't stop long-running queries.  The timer only starts when 
there is no client request outstanding.

Sue