Remark for SQLGetConnectAttr

List of all supported attributes and return codes of the MaxDB ODBC driver

Attributes

Return Codes

SQL_ ATTR_ACCESS_MODE

pvParam = SQL_MODE_READ_WRITE

SQL_ ATTR_AUTOCOMMIT

pvParam = SQL_AUTOCOMMIT_ON

SQL_ATTR_CONNECTION_DEAD

 

SQL_ATTR_CURRENT_CATALOG

 

SQL_ ATTR_LOGIN_TIMEOUT

pvParam = 15

SQL_ATTR_ODBC_CURSORS

 

SQL_ATTR_QUIET_MODE

 

SQL_ ATTR_OPT_TRACE

pvParam = SQL_OPT_TRACE_OFF =0

SQL_ ATTR_OPT_TRACEFILE

(The file name set with SQLSetConnectAttr,
default value:
\SQL.LOG)

SQL_ ATTR_TRANSLATE_LIB

 

SQL_ ATTR_TRANSLATE_OPTION

pvParam = 0

SQL_ ATTR_TXN_ISOLATION

pvParam = SQL_TXN_REPEATABLE_READ

SQL_ MODE = SQL_CONNECT_OPT_START + 2

pvParam = (1 = INTERNAL, 2 = DB2, 3 = ANSI,  4 = ORACLE)