sqlipGetInfo
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
This connection-level method is called by the OpenAccess SDK layer to request information from the IP.
int sqlipGetInfo(
int InfoType,
StringBuffer sInfoValue);
Parameters for sqlipGetInfo
| Parameter | Type | Description |
| INPUT | ||
| iInfoType | int | Option – see Table GetInfo Options. |
| OUTPUT | ||
| sInfoValue | StringBuffer | Buffer into which to return the data. |
| RETURN | ||
| int | OADS_SUCCESS – if the requested option is supported. OADS_ERROR – error occurred in obtaining the requested information. |
The following table describes the options used by the sqlipGetInfo method.
GetInfo Options
| iInfoType | 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_ADDRESS | Connection level information. Returns the local IP address of the client as a string of the form "ddd.ddd.ddd.ddd" (for example, "100.23.24.25"). The value is a string of maximum 128 characters. This option can be used while running in client-server mode to implement a client IP-based authentication scheme. |
| OADS_CONN_INFO_CLIENT_APPLICATION | Connection level information indicating the name of the client application on this connection. The value is an ASCII string of maximum length 128. |
| OADS_CONN_INFO_CURRENT_QUALIFIER | The current qualifier/database. If not applicable, it returns an empty string. |
| OADS_CONN_INFO_CLIENT_PUBLIC_ADDRESS | Connection level information. Returns the public IP address of the client as a string of the form "ddd.ddd.ddd.ddd" (for example, "100.23.24.25"). The value is a string of maximum 128 characters. This option can be used while running in client-server mode to implement a client IP-based authentication scheme. |
| OADS_CONN_INFO_CLIENT_TYPE | Connection level information indicating the OpenAccess SDK client type for this connection. The value is a short integer. The possible values are: |
| 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. |