|
Attribute
|
Value (option)
|
Driver manager
|
Driver alone
|
Comments
|
|---|---|---|---|---|
|
SQL_ATTR_ODBC_CURSORS
|
SQL_CUR_IF_NEEDED
SQL_FETCH_PRIOR
SQL_CUR_USE_ODBC
SQL_CUR_ USE_DRIVER
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
ACCESS_MODE |
SQL_MODE_ READ_ONLY
SQL_MODE_ READ_WRITE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
ASYNC_ENABLE |
SQL_ASYNC_ ENABLE_OFF
SQL_ASYNC_ ENABLE_ON
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
AUTO_IPD |
SQL_TRUE SQL_FALSE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
AUTOCOMMIT |
SQL_ATTR_ AUTOCOMMIT_OFF
SQL_ATTR_ AUTOCOMMIT_ON
|
All values are supported
|
All values are supported
|
|
|
SQL_ATTR_
CONNECTION_ TIMEOUT |
Timeout value in sec
|
Supported
|
Supported
|
|
|
SQL_ATTR_ CURRENT_
CATALOG |
CatalogName
|
Supported
|
Supported
|
|
|
SQL_ATTR_ LOGIN_TIMEOUT
|
Timeout value in sec
|
Supported
|
Supported
|
|
|
SQL_ATTR_ METADATA_ID
|
SQL_TRUE SQL_FALSE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
PACKET_SIZE |
Packet size in bytes
|
the desired size
|
Not supported
|
|
|
SQL_ATTR_QUIET_MODE
|
Set to NULL
|
can set and get
|
Not supported
|
|
|
SQL_ATTR_
TRACE |
SQL_TRACE_OFF SQL_TRACE_ON
|
All values supported
|
All values not supported
|
All values handled by DM, not by driver
|
|
SQL_ATTR_TRACEFILE
|
Pointer to trace file name
|
Supported
|
Not supported
|
Handled by DM, not by driver
|
|
SQL_ATTR_TRNSLATE_LIB
|
Pointer Name of lib
|
Supported
|
Not supported
|
Handled by DM, not by driver
|
|
SQL_ATTR_TXN_ISOLATION
|
SQL_TXN_ SERIALIZABLE
SQL_TXN_READ_ UNCOMMITTED
SQL_TXN_READ_ COMMITTED
SQL_TXN_REPEATABLE_READ
|
All values are supported, except SQL_TXN_READ_UNCOMMITTED
|
All values are supported, except SQL_TXN_READ_UNCOMMITTED
|
solidDB does not support the READ_UNCOMMITTED feature.
|