Documentation

ODBC Driver Guide

Previous Topic

Next Topic

Supported Environment, Connection, and Statement Attributes

The following table details the driver attributes that the c-treeACE ODBC Driver supports. Applications can set and retrieve supported driver attributes through the following routines:

  • SQLGetEnvAttr() and SQLSetEnvAttr() for environment attributes
  • SQLGetConnectAttr() and SQLSetConnectAttr() for connection attributes
  • SQLGetStmtAttr() and SQLSetStmtAttr() for statement attributes

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

TOCIndex