New Connection Strings for OLE DB Applications

The new set of connection strings for OLE DB applications is introduced.

Property names

Description

Required

Default value

ProtocolCapture

Enable this property to capture communication between an OLE DB application and the server.

See Adaptive Server Enterprise OLE DB Provider Users Guide.

No

Empty

RetryCount, RetryDelay

Control the connection retry behavior.

RetryCount is the number of times to attempt to connect to the server before reporting the connection failed. Between each retry, the driver delays for RetryDelay number of seconds.

By default, the OLE DB application does not retry the connection.

You can also specify these values in SQL.INI and LDAP interfaces:
  • RetryCount can be specified as Retry Count in SQL.INI and as sybaseRetryCount in LDAP.

  • RetryDelay can be specified as Loop Delay in SQL.INI and as sybaseRetryDelay in LDAP.

No

0

SuppressControlTokens

Specifies that Adaptive Server should not send TDS_CONTROL tokens.

Values:
  • 0 – forces Adaptive Server to send TDS_CONTROL tokens where possible.

  • 1– the default value; forces Adaptive Server to suppress TDS_CONTROL tokens.

No

1

SuppressParamFormat

Specifies that the OLE DB application should send parameter format tokens only when the format changes.

Values:
  • 0 – forces the OLE DB application to always send the parameter format tokens on every execution.

  • 1– the default value; requests the OLE DB application to suppress sending parameter format tokens when the format has already been set.

No

1

SuppressRowFormat

Specifies that Adaptive Server should send row format tokens only on first execution or when the format changes.

Values:
  • 0 – forces Adaptive Server to send the format information on every execution.

  • 1– the default value; requests Adaptive Server to suppress sending row format tokens when possible.

No

1

SuppressRowFormat2

Specifies that Adaptive Server should send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence.

Values:
  • 0 – the default value; forces Adaptive Server to send data in TDS_ROWFMT2 where possible.

  • 1– forces Adaptive Server to send data in TDS_ROWFMT where possible.

See Adaptive Server Enterprise OLE DB Provider Users Guide.

No

0