-22005: Connection timeout occurred. Session reconnected


The user's transaction was canceled and reset by a ROLLBACK statement. The database session was terminated because the user failed to carry out any operations during a certain period of time (special database parameter SESSION_TIMEOUT, or the timeout value specified in the CONNECT statement).

The ODBC driver recognizes the timeout in this type of instance and automatically logs the user back on to the database instance using the original parameters (user name, password, database name, server host, etc.). Each statement from the relevant session signals this with return code SQL_SUCCESS_WITH_INFO and message -22005.

User Response:

Every statement that has a result set (CURSOR) must be executed again in order to ensure that the result sets are built up again. If the connection is set to SQL_AUTOCOMMIT_OFF, all the other statements that were in an open transaction must also be executed again.