| 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 | 
       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.R | Title | User | Personal Name | Date | Lines | 
|---|---|---|---|---|---|
| 1291.1 | M5::JBALOGH | Tue Jan 28 1997 09:00 | 6 | ||
|     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.2 | Idle User Timeout in 7.0 | SQLSRV::MAVRIS | Sue Mavris - [email protected] | Tue Jan 28 1997 10:22 | 8 | 
| 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 | |||||