|
|
|
The following table details the driver attributes that the FairCom DB ODBC Driver supports. Applications can set and retrieve supported driver attributes through the following routines:
Supported Environment, Connection, and Statement Attributes
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 |
Yes |
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 (Supported both as statement attribute and connection attribute. If it is used as a connection attribute, it will override the statement attribute.) |
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 |
