Changes to SQLSetConnectAttr() attributes
For SQLSetConnectAttr() attributes, the
ODBC driver supports both ODBC 2.0 and ODBC 3.0 values.
The following table correlates ODBC 2.0 and ODBC 3.0 values.
| ODBC 2.0 attribute | ODBC 3.0 attribute |
|---|---|
| SQL_ACCESS_MODE | SQL_ATTR_ACCESS_MODE |
| SQL_AUTOCOMMIT | SQL_ATTR_AUTOCOMMIT |
| SQL_CONNECTTYPE | SQL_ATTR_CONNECTTYPE |
| SQL_CURRENT_SCHEMA | SQL_ATTR_CURRENT_SCHEMA |
| SQL_MAXCONN | SQL_ATTR_MAXCONN |
| SQL_PARAMOPT_ATOMIC | SQL_ATTR_PARAMOPT_ATOMIC |
| SQL_SYNC_POINT | SQL_ATTR_SYNC_POINT |
| SQL_TXN_ISOLATION | SQL_ATTR_TXN_ISOLATION |