-22005: Connection timeout occurred. Session reconnected

Explanation

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 SessionTimeout, 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 using the original parameters (user name, password, database name, server host, and so on). 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.