The following table details the driver attributes that the c-treeSQL ODBC Driver supports. Applications can set and retrieve supported driver attributes through the following routines:
Attribute
|
Supported
|
ODBC Environment Attributes
|
|
SQL_ATTR_CONNECTION_POOLING
|
No
|
SQL_ATTR_CP_MATCH
|
No
|
SQL_ATTR_ODBC_VER
|
Yes
|
SQL_ATTR_OUTPUT_NTS
|
Yes
|
ODBC Connection Attributes
|
|
SQL_ATTR_ACCESS_MODE
|
Yes (supports both read_only and read_write connection modes)
|
SQL_ATTR_ASYNC_ENABLE
|
Yes (supports only SQL_ASYNC_ENABLE_OFF, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_AUTO_IPD
|
Yes
|
SQL_ATTR_AUTOCOMMIT
|
Yes
|
SQL_ATTR_CONNECTION_TIMEOUT
|
Yes (supports only 0, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_CURRENT_CATALOG
|
No
|
SQL_ATTR_LOGIN_TIMEOUT
|
Yes
The default value is 15 seconds.
|
SQL_ATTR_ODBC_CURSORS
|
Yes
|
SQL_ATTR_PACKET_SIZE
|
Yes (supports only default, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_QUIET_MODE
|
Yes (supports only default, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_TRACE
|
No
|
SQL_ATTR_TRACEFILE
|
No
|
SQL_ATTR_TRANSLATE_DLL
|
No
|
SQL_ATTR_TRANSLATE_LIB
|
No
|
SQL_ATTR_TRANSLATE_OPTION
|
No
|
SQL_ATTR_TXN_ISOLATION
|
Yes
|
ODBC Statement Attributes
|
|
SQL_ATTR_APP_PARAM_DESC
|
Yes
|
SQL_ATTR_APP_ROW_DESC
|
Yes
|
SQL_ATTR_ASYNC_ENABLE
|
Yes (supports only SQL_ASYNC_ENABLE_OFF, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_CONCURRENCY
|
Yes (supports only SQL_CONCUR_READ_ONLY, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_CURSOR_SCROLLABLE
|
No
|
SQL_ATTR_CURSOR_TYPE
|
Yes (supports only SQL_FORWARD_ONLY, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_CURSOR_SENSITIVITY
|
Yes (supports only SQL_INSENSITIVE, for other values returns warning “Option value changed” and sets to default)
|
SQL_ATTR_ENABLE_AUTO_IPD
|
No
|
SQL_ATTR_FETCH_BOOKMARK_PTR
|
No
|
SQL_ATTR_IMP_PARAM_DESC
|
Yes
|
SQL_ATTR_IMP_ROW_DESC
|
Yes
|
SQL_ATTR_KEYSET_SIZE
|
No
|
SQL_ATTR_MAX_LENGTH
|
No
|
SQL_ATTR_MAX_ROWS
|
Yes
|
SQL_ATTR_METADATA_ID
|
Yes
|
SQL_ATTR_NOSCAN
|
No
|
SQL_ATTR_PARAM_BIND_OFFSET_PTR
|
Yes
|
SQL_ATTR_PARAM_BIND_TYPE
|
Yes
|
SQL_ATTR_PARAM_OPERATION_PTR
|
Yes
|
SQL_ATTR_PARAM_STATUS_PTR
|
Yes
|
SQL_ATTR_PARAMS_PROCESSED_PTR
|
Yes
|
SQL_ATTR_PARAMSET_SIZE
|
Yes
|
SQL_ATTR_QUERY_TIMEOUT
|
Yes (defaults to 30 sec)
|
SQL_ATTR_RETRIEVE_DATA
|
Yes
|
SQL_ATTR_ROW_ARRAY_SIZE
|
Yes
|
SQL_ATTR_ROW_BIND_OFFSET_PTR
|
Yes
|
SQL_ATTR_ROW_BIND_TYPE
|
Yes
|
SQL_ATTR_ROW_NUMBER
|
No
|
SQL_ATTR_ROW_OPERATION_PTR
|
Yes
|
SQL_ATTR_ROW_STATUS_PTR
|
Yes
|
SQL_ATTR_ROWS_FETCHED_PTR
|
Yes
|
SQL_ATTR_SIMULATE_CURSOR
|
No
|
SQL_ATTR_USE_BOOKMARKS
|
No
|
