Determines whether packets are sent to the database to ensure that the connection is still active.
When to specify KeepAlive You must specify the KeepAlive parameter before connecting to the database.
ASE, SYC Sybase Adaptive Server Enterprise
KeepAlive=value
Parameter |
Description |
---|---|
value |
Specifies whether the Open Client/Server CS_CON_KEEPALIVE property is set for your connection. Values are:
|
KeepAlive=1
KeepAlive sets the value of the Sybase CT-Lib connection property CS_CON_KEEPALIVE to true or false. The default setting ensures that your connection is alive by sending packets to the database when the connection is idle. Set the value of this property to false for mobile clients that do not maintain constant connections.
To set the KeepAlive value to 0 when you do not want to maintain a connection:
Database profile Clear the Keep Connection Alive check box on the Network page.
Application Type the following in code:
SQLCA.DBParm="KeepAlive=0"