|
Parameter
|
Type
|
Description
|
|
INPUT
|
|
|
|
sqlip_hdbc
|
SQLIP_HDBC
|
Connection handle.
|
|
iInfoType
|
OADS_INTEGER
|
Information type. See Table 49 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.
|
|
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:
• SQLDRV_CLIENTTYPE_ODBC
• SQLDRV_CLIENTTYPE_JDBC
• SQLDRV_CLIENTTYPE_OLEDB
• SQLDRV_CLIENTTYPE_NET
|
|
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 |
An integer value indicating the cryptographic protocol version that can be used to create an SSL connection between the OpenAccess SDK client and server.
Valid or expected values are the following SSL/TLS versions:
• DAM_VERSION_UNDEFINED – 0
• DAM_VERSION_TLS1 – 1
• DAM_VERSION_TLS1_1 – 2
• DAM_VERSION_TLS1_2 – 3
• Default when SSL Enabled DAM_VERSION_TLS1_2 – 2 |
|
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.
|