KeepAlive

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:

  • 1

    (Default) CS_CON_KEEPALIVE property is set.

  • 0

    CS_CON_KEEPALIVE property is not set.


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"