Specifies whether to keep the connection open between commands, such as issuing an SQL statement or changing an ODBC driver setting.
-
If this setting is 0, the SQL outbound adapter disconnects immediately after each command.
-
If this setting is positive, it specifies the idle time, in seconds, after the command completes. The adapter disconnects after this idle time.
-
If this setting is –1, the adapter auto-connects on startup and then stays connected.
If you are managing database transactions as described in Managing Transactions, do not set StayConnected to 0.