ODBC Attribute Support

ODBC Attribute Support

The Relational Interface provides ODBC v3.51 attribute support, with the exceptions listed here.

Connection Attribute Support

The following table lists the exceptions to ODBC connection attribute support:

Table 2

Exceptions to ODBC Connection Attribute Support

SQL_ATTR_AUTO_IPD

The default value is SQL_TRUE. The Pervasive ODBC Driver does not allow setting this attribute value to SQL_FALSE.

SQL_ATTR_CONNECTION_TIMEOUT

The default value is 0. No other value is supported.

SQL_ATTR_METADATA_ID

The default value is SQL_FALSE. The Pervasive ODBC Driver does not allow setting this attribute's value to SQL_TRUE

Statement Attribute Support

The following table lists the exceptions to ODBC statement attribute support:

Table 3

Exceptions to ODBC Statement Attribute Support

fOption (numerical value)

SQL_ATTR_ENABLE_AUTO_IPD (15)

The default value is SQL_TRUE. Pervasive ODBC Driver does not allow setting this attribute value to SQL_FALSE.

SQL_ATTR_METADATA_ID (10014)

The default value is SQL_FALSE. Pervasive ODBC Driver does not allow setting this attribute's value to SQL_TRUE.

SQL_ATTR_PARAM_BIND_TYPE (18)

Only SQL_PARAM_BIND_BY_COLUMN is supported.

SQL_ATTR_QUERY_TIMEOUT (0)

Supported through SQLSetStmtAttr and SQLSetConnectAttr. Applies only to SQLExecDirect, SQLExecute, SQLFetch, and SQLExtendedFetch. Does not apply to DDL statements.