OASQLIP_set_connect_info
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This function is called set connection related information such as the current qualifier, transaction isolation, and auto-commit mode.
int OASQLIP_set_connect_info(
SQLIP_HDBC sqlip_hdbc,
OADS_INTEGER iInfoType,
OADS_POINTER CharValue,
OADS_INTEGER iValueLen,
OADS_LEN NumericValue)
Parameters for OASQLIP_set_connect_info
| Parameter | Type | Description |
| INPUT | ||
| sqlip_hdbc | SQLIP_HDBC | Connection handle. |
| iInfoType | OADS_INTEGER | Information type. See Table Connection Options for OASQLIP_get_connect_info Options for the connection options. |
| CharValue | OADS_POINTER | Buffer containing character data as an OAWCHAR string. |
| iValueLen | OADS_INTEGER | Length of the string value in CharValue. |
| NumericValue | OADS_LEN | Integer buffer to use for setting numeric attribute values. |
| RETURN | ||
| int | OADS_SUCCESS – if you are able to successfully apply the option or if you want to ignore the options. OADS_ERROR – if error in handling the requested option for which you do have support. |
Connection Options for OASQLIP_get_connect_info Options
| Information Type | Description |
| OADS_CONN_INFO_AUTOCOMMIT | An integer value indicating whether auto commit is on or off. SQL_AUTOCOMMIT_OFF (0) – Auto-commit is off. Transactions must be explicitly committed. SQL_AUTOCOMMIT_ON (1) – Auto-commit is on. The data source will implicitly commit transactions after a statement is executed. |
| OADS_CONN_INFO_CLIENT_ PROD_VERSION |
A string value indicating the version of the client product that the OpenAccess SDK client is accessing for this connection. |
| OADS_CONN_INFO_CLIENT_TYPE | An integer value indicating the OpenAccess SDK client type (ODBC, JDBC, OLE DB, or ADO.NET). Valid values: |
| OADS_CONN_INFO_CURRENT_QUALIFIER | The current qualifier/database. If not applicable, then return an empty string. |
| OADS_CONN_INFO_SESSION_ CIPHER_SUITE |
A string value indicating the cipher suite used for communication between the OpenAccess SDK client and server. |
| OADS_CONN_INFO_SESSION_ CRYPTO_PROTOCOL_VERSION |
Connection level information. Returns the cryptographic protocol version that can be used to create an SSL connection between the OpenAccess SDK client and server. The value returned is an integer data type. Valid or expected values are the following SSL/TLS versions:
|
| OADS_CONN_INFO_TXN_ISOLATION | An integer value indicating the transaction isolation level. SQL_TXN_READ_UNCOMMITTED(1) – Dirty reads, non-repeatable reads, and phantom reads are possible. SQL_TXN_READ_COMMITTED(2) – Dirty reads are not possible. Non-repeatable reads and phantom reads are possible. This is the default. SQL_TXN_REPEATABLE_READ(4) – Dirty reads and reads that cannot be repeated are not possible. Phantoms are possible. SQL_TXN_SERIALIZABLE (8) – Transactions can be serialized. Dirty reads, non-repeatable reads, and phantoms are not possible. |