Description
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.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
KeepAlive=value
Parameter |
Description |
---|---|
value |
Specifies whether the Open Client/Server CS_CON_KEEPALIVE property is set for your connection. Values are:
|
Default value
KeepAlive=1
Usage
KeepAlive sets the value of the SAP 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.
Examples
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"