Test environment:
MS ODBC Test 2.60.0905
MS Access Driver (*.mdb) 4.00.6019
Attached is the (slightly edited) output of 'Get Info All'.
Steffen
20 SQL_ACCESSIBLE_PROCEDURES "Y"
19 SQL_ACCESSIBLE_TABLES "Y"
0 SQL_ACTIVE_CONNECTIONS 64
116 SQL_ACTIVE_ENVIRONMENTS 0
1 SQL_ACTIVE_STATEMENTS 0
117 SQL_ALTER_DOMAIN 0x00000000
86 SQL_ALTER_TABLE 0x00000003 SQL_AT_ADD_COLUMN
| SQL_AT_DROP_COLUMN
10021 SQL_ASYNC_MODE 0 SQL_AM_NONE
120 SQL_BATCH_ROW_COUNT 0x00000000
121 SQL_BATCH_SUPPORT 0x00000000
82 SQL_BOOKMARK_PERSISTENCE 0x00000050 SQL_BP_UPDATE |
SQL_BP_SCROLL
114 SQL_CATALOG_LOCATION 1 SQL_CL_START
10003 SQL_CATALOG_NAME "Y"
41 SQL_CATALOG_NAME_SEPARATOR "."
42 SQL_CATALOG_TERM "DATABASE"
92 SQL_CATALOG_USAGE 0x0000000D
SQL_CU_DML_STATEMENTS | SQL_CU_TABLE_DEFINITION | SQL_CU_INDEX_DEFINITION
10004 SQL_COLLATION_SEQ ""
87 SQL_COLUMN_ALIAS "Y"
22 SQL_CONCAT_NULL_BEHAVIOR 1 SQL_CB_NON_NULL
53 SQL_CONVERT_BIGINT 0x00000000
54 SQL_CONVERT_BINARY 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
55 SQL_CONVERT_BIT 0x00000000
56 SQL_CONVERT_CHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
57 SQL_CONVERT_DATE 0x00000000
58 SQL_CONVERT_DECIMAL 0x00000000
59 SQL_CONVERT_DOUBLE 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
60 SQL_CONVERT_FLOAT 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
48 SQL_CONVERT_FUNCTIONS 0x00000001 SQL_FN_CVT_CONVERT
61 SQL_CONVERT_INTEGER 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
123 SQL_CONVERT_INTERVAL_DAY_TIME 0x00000000
124 SQL_CONVERT_INTERVAL_YEAR_MONTH 0x00000000
71 SQL_CONVERT_LONGVARBINARY 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
62 SQL_CONVERT_LONGVARCHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
63 SQL_CONVERT_NUMERIC 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
64 SQL_CONVERT_REAL 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
65 SQL_CONVERT_SMALLINT 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
66 SQL_CONVERT_TIME 0x00000000
67 SQL_CONVERT_TIMESTAMP 0x00000000
68 SQL_CONVERT_TINYINT 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
69 SQL_CONVERT_VARBINARY 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
70 SQL_CONVERT_VARCHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
122 SQL_CONVERT_WCHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
125 SQL_CONVERT_WLONGVARCHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
126 SQL_CONVERT_WVARCHAR 0x008001FA SQL_CVT_NUMERIC |
SQL_CVT_INTEGER | SQL_CVT_SMALLINT | SQL_CVT_FLOAT | SQL_CVT_REAL | SQL_CVT_DOUBLE |
SQL_CVT_VARCHAR | SQL_CVT_WVARCHAR
74 SQL_CORRELATION_NAME 2 SQL_CN_ANY
127 SQL_CREATE_ASSERTION 0x00000000
128 SQL_CREATE_CHARACTER_SET 0x00000000
129 SQL_CREATE_COLLATION 0x00000000
130 SQL_CREATE_DOMAIN 0x00000000
131 SQL_CREATE_SCHEMA 0x00000000
132 SQL_CREATE_TABLE 0x00000001
SQL_CT_CREATE_TABLE
133 SQL_CREATE_TRANSLATION 0x00000000
134 SQL_CREATE_VIEW 0x00000001 SQL_CV_CREATE_VIEW
23 SQL_CURSOR_COMMIT_BEHAVIOR 1 SQL_CB_CLOSE
24 SQL_CURSOR_ROLLBACK_BEHAVIOR 1 SQL_CB_CLOSE
10001 SQL_CURSOR_SENSITIVITY 0 SQL_UNSPECIFIED
16 SQL_DATABASE_NAME "C:\tmp\test"
2 SQL_DATA_SOURCE_NAME "test"
25 SQL_DATA_SOURCE_READ_ONLY "N"
119 SQL_DATETIME_LITERALS 0x00000000
17 SQL_DBMS_NAME "ACCESS"
18 SQL_DBMS_VER "03.50.0000"
26 SQL_DEFAULT_TXN_ISOLATION 2
SQL_TXN_READ_COMMITTED
10002 SQL_DESCRIBE_PARAMETER "N"
171 SQL_DM_VER "03.52.6019.0000"
3 SQL_DRIVER_HDBC 0x00236D8C
135 SQL_DRIVER_HDESC 0x002383D4
4 SQL_DRIVER_HENV 0x00236D70
76 SQL_DRIVER_HLIB 0x1F8F0000
5 SQL_DRIVER_HSTMT 0x00238060
6 SQL_DRIVER_NAME "odbcjt32.dll"
77 SQL_DRIVER_ODBC_VER "03.51"
7 SQL_DRIVER_VER "04.00.6019"
136 SQL_DROP_ASSERTION 0x00000000
137 SQL_DROP_CHARACTER_SET 0x00000000
138 SQL_DROP_COLLATION 0x00000000
139 SQL_DROP_DOMAIN 0x00000000
140 SQL_DROP_SCHEMA 0x00000000
141 SQL_DROP_TABLE 0x00000001 SQL_DT_DROP_TABLE
142 SQL_DROP_TRANSLATION 0x00000000
143 SQL_DROP_VIEW 0x00000001 SQL_DV_DROP_VIEW
144 SQL_DYNAMIC_CURSOR_ATTRIBUTES1 0x00000000
145 SQL_DYNAMIC_CURSOR_ATTRIBUTES2 0x00000000
27 SQL_EXPRESSIONS_IN_ORDERBY "Y"
8 SQL_FETCH_DIRECTION 0x000000BF SQL_FD_FETCH_NEXT
| SQL_FD_FETCH_FIRST | SQL_FD_FETCH_LAST | SQL_FD_FETCH_PRIOR | SQL_FD_FETCH_ABSOLUTE
| SQL_FD_FETCH_RELATIVE | SQL_FD_FETCH_BOOKMARK
84 SQL_FILE_USAGE 2 SQL_FILE_CATALOG
146 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 0x00000001 SQL_CA1_NEXT
147 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 0x00000001
SQL_CA2_READ_ONLY_CONCURRENCY
81 SQL_GETDATA_EXTENSIONS 0x0000000F SQL_GD_ANY_COLUMN
| SQL_GD_ANY_ORDER | SQL_GD_BLOCK | SQL_GD_BOUND
88 SQL_GROUP_BY 2
SQL_GB_GROUP_BY_CONTAINS_SELECT
28 SQL_IDENTIFIER_CASE 3 SQL_IC_SENSITIVE
29 SQL_IDENTIFIER_QUOTE_CHAR "`"
148 SQL_INDEX_KEYWORDS 0x00000003 SQL_IK_ASC |
SQL_IK_DESC
149 SQL_INFO_SCHEMA_VIEWS 0x00000000
73 SQL_INTEGRITY "N"
150 SQL_KEYSET_CURSOR_ATTRIBUTES1 0x000F1E4F SQL_CA1_NEXT |
SQL_CA1_ABSOLUTE | SQL_CA1_RELATIVE | SQL_CA1_BOOKMARK | SQL_CA1_LOCK_NO_CHANGE |
SQL_CA1_POS_POSITION | SQL_CA1_POS_UPDATE | SQL_CA1_POS_DELETE | SQL_CA1_POS_REFRESH |
SQL_CA1_BULK_ADD | SQL_CA1_BULK_UPDATE_BY_BOOKMARK | SQL_CA1_BULK_DELETE_BY_BOOKMARK |
SQL_CA1_BULK_FETCH_BY_BOOKMARK
151 SQL_KEYSET_CURSOR_ATTRIBUTES2 0x0000007F
SQL_CA2_READ_ONLY_CONCURRENCY | SQL_CA2_LOCK_CONCURRENCY |
SQL_CA2_OPT_ROWVER_CONCURRENCY | SQL_CA2_OPT_VALUES_CONCURRENCY |
SQL_CA2_SENSITIVITY_ADDITIONS | SQL_CA2_SENSITIVITY_DELETIONS |
SQL_CA2_SENSITIVITY_UPDATES
89 SQL_KEYWORDS
"ALPHANUMERIC,AUTOINCREMENT,BINARY,BYTE,COUNTER,CURRENCY,DATABASE,DATABASENAME,DATETIME,DISALLOW,DISTINCTROW,DOUBLEFLOAT,FLOAT4,FLOAT8,GENERAL,IEEEDOUBLE,IEEESINGLE,IGNORE,INT,INTEGER1,INTEGER2,INTEGER4,LEVEL,LOGICAL,LOGICAL1,LONG,LONGBINARY,LONGCHAR,LONGTEXT,MEMO,MONEY,NOTE,NUMBER,OLEOBJECT,OPTION,"
113 SQL_LIKE_ESCAPE_CLAUSE "N"
78 SQL_LOCK_TYPES 0x00000001 SQL_LCK_NO_CHANGE
10022 SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 0
112 SQL_MAX_BINARY_LITERAL_LEN 255
34 SQL_MAX_CATALOG_NAME_LEN 260
108 SQL_MAX_CHAR_LITERAL_LEN 255
97 SQL_MAX_COLUMNS_IN_GROUP_BY 10
98 SQL_MAX_COLUMNS_IN_INDEX 10
99 SQL_MAX_COLUMNS_IN_ORDER_BY 10
100 SQL_MAX_COLUMNS_IN_SELECT 255
101 SQL_MAX_COLUMNS_IN_TABLE 255
30 SQL_MAX_COLUMN_NAME_LEN 64
1 SQL_MAX_CONCURRENT_ACTIVITIES 0
31 SQL_MAX_CURSOR_NAME_LEN 64
0 SQL_MAX_DRIVER_CONNECTIONS 64
10005 SQL_MAX_IDENTIFIER_LEN 64
102 SQL_MAX_INDEX_SIZE 83
32 SQL_MAX_OWNER_NAME_LEN 0
33 SQL_MAX_PROCEDURE_NAME_LEN 64
34 SQL_MAX_QUALIFIER_NAME_LEN 260
104 SQL_MAX_ROW_SIZE 2096
103 SQL_MAX_ROW_SIZE_INCLUDES_LONG "N"
32 SQL_MAX_SCHEMA_NAME_LEN 0
105 SQL_MAX_STATEMENT_LEN 65000
106 SQL_MAX_TABLES_IN_SELECT 16
35 SQL_MAX_TABLE_NAME_LEN 64
107 SQL_MAX_USER_NAME_LEN 0
37 SQL_MULTIPLE_ACTIVE_TXN "Y"
36 SQL_MULT_RESULT_SETS "N"
111 SQL_NEED_LONG_DATA_LEN "N"
75 SQL_NON_NULLABLE_COLUMNS 0 SQL_NNC_NULL
85 SQL_NULL_COLLATION 1 SQL_NC_LOW
49 SQL_NUMERIC_FUNCTIONS 0x0052FF69 SQL_FN_NUM_ABS |
SQL_FN_NUM_ATAN | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_EXP |
SQL_FN_NUM_FLOOR | SQL_FN_NUM_LOG | SQL_FN_NUM_MOD | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN
| SQL_FN_NUM_SQRT | SQL_FN_NUM_TAN | SQL_FN_NUM_RAND | SQL_FN_NUM_POWER |
SQL_FN_NUM_ROUND
9 SQL_ODBC_API_CONFORMANCE 1 SQL_OAC_LEVEL1
152 SQL_ODBC_INTERFACE_CONFORMANCE 3 SQL_OIC_LEVEL2
12 SQL_ODBC_SAG_CLI_CONFORMANCE 0
SQL_OSCC_NOT_COMPLIANT
15 SQL_ODBC_SQL_CONFORMANCE 0 SQL_OSC_MINIMUM
73 SQL_ODBC_SQL_OPT_IEF "N"
10 SQL_ODBC_VER "03.52.0000"
115 SQL_OJ_CAPABILITIES 0x00000053 SQL_OJ_LEFT |
SQL_OJ_RIGHT | SQL_OJ_NOT_ORDERED | SQL_OJ_ALL_COMPARISON_OPS
90 SQL_ORDER_BY_COLUMNS_IN_SELECT "N"
38 SQL_OUTER_JOINS "Y"
39 SQL_OWNER_TERM ""
91 SQL_OWNER_USAGE 0x00000000
153 SQL_PARAM_ARRAY_ROW_COUNTS 2 SQL_PARC_NO_BATCH
154 SQL_PARAM_ARRAY_SELECTS 2 SQL_PAS_NO_BATCH
80 SQL_POSITIONED_STATEMENTS 0x00000000
79 SQL_POS_OPERATIONS 0x0000001F SQL_POS_POSITION
| SQL_POS_REFRESH | SQL_POS_UPDATE | SQL_POS_DELETE | SQL_POS_ADD
21 SQL_PROCEDURES "Y"
40 SQL_PROCEDURE_TERM "QUERY"
114 SQL_QUALIFIER_LOCATION 1 SQL_CL_START
41 SQL_QUALIFIER_NAME_SEPARATOR "."
42 SQL_QUALIFIER_TERM "DATABASE"
92 SQL_QUALIFIER_USAGE 0x0000000D
SQL_CU_DML_STATEMENTS | SQL_CU_TABLE_DEFINITION | SQL_CU_INDEX_DEFINITION
93 SQL_QUOTED_IDENTIFIER_CASE 4 SQL_IC_MIXED
11 SQL_ROW_UPDATES "N"
39 SQL_SCHEMA_TERM ""
91 SQL_SCHEMA_USAGE 0x00000000
43 SQL_SCROLL_CONCURRENCY 0x0000000B
SQL_SCCO_READ_ONLY | SQL_SCCO_LOCK | SQL_SCCO_OPT_VALUES
44 SQL_SCROLL_OPTIONS 0x00000013
SQL_SO_FORWARD_ONLY | SQL_SO_KEYSET_DRIVEN | SQL_SO_STATIC
14 SQL_SEARCH_PATTERN_ESCAPE "\"
13 SQL_SERVER_NAME "ACCESS"
94 SQL_SPECIAL_CHARACTERS "~@#$%^&*_-+=\}{"';:?/><,.![]|"
155 SQL_SQL92_DATETIME_FUNCTIONS 0x00000000
156 SQL_SQL92_FOREIGN_KEY_DELETE_RULE 0x00000000
157 SQL_SQL92_FOREIGN_KEY_UPDATE_RULE 0x00000000
158 SQL_SQL92_GRANT 0x00000000
159 SQL_SQL92_NUMERIC_VALUE_FUNCTIONS 0x00000000
160 SQL_SQL92_PREDICATES 0x00000000
161 SQL_SQL92_RELATIONAL_JOIN_OPERATORS 0x00000000
162 SQL_SQL92_REVOKE 0x00000000
163 SQL_SQL92_ROW_VALUE_CONSTRUCTOR 0x00000000
164 SQL_SQL92_STRING_FUNCTIONS 0x00000000
165 SQL_SQL92_VALUE_EXPRESSIONS 0x00000000
118 SQL_SQL_CONFORMANCE 1 SQL_SC_SQL92_ENTRY
166 SQL_STANDARD_CLI_CONFORMANCE 0x00000000
167 SQL_STATIC_CURSOR_ATTRIBUTES1 0x0008120F SQL_CA1_NEXT |
SQL_CA1_ABSOLUTE | SQL_CA1_RELATIVE | SQL_CA1_BOOKMARK | SQL_CA1_POS_POSITION |
SQL_CA1_POS_REFRESH | SQL_CA1_BULK_FETCH_BY_BOOKMARK
168 SQL_STATIC_CURSOR_ATTRIBUTES2 0x00000001
SQL_CA2_READ_ONLY_CONCURRENCY
83 SQL_STATIC_SENSITIVITY 0x00000007 SQL_SS_ADDITIONS
| SQL_SS_DELETIONS | SQL_SS_UPDATES
50 SQL_STRING_FUNCTIONS 0x00057E7D SQL_FN_STR_CONCAT
| SQL_FN_STR_LEFT | SQL_FN_STR_LTRIM | SQL_FN_STR_LENGTH | SQL_FN_STR_LOCATE |
SQL_FN_STR_LCASE | SQL_FN_STR_RIGHT | SQL_FN_STR_RTRIM | SQL_FN_STR_SUBSTRING |
SQL_FN_STR_UCASE | SQL_FN_STR_ASCII | SQL_FN_STR_CHAR | SQL_FN_STR_LOCATE_2 |
SQL_FN_STR_SPACE
95 SQL_SUBQUERIES 0x0000001F SQL_SQ_COMPARISON
| SQL_SQ_EXISTS | SQL_SQ_IN | SQL_SQ_QUANTIFIED | SQL_SQ_CORRELATED_SUBQUERIES
51 SQL_SYSTEM_FUNCTIONS 0x00000000
45 SQL_TABLE_TERM "TABLE"
109 SQL_TIMEDATE_ADD_INTERVALS 0x00000000
110 SQL_TIMEDATE_DIFF_INTERVALS 0x00000000
52 SQL_TIMEDATE_FUNCTIONS 0x00019FFF SQL_FN_TD_NOW |
SQL_FN_TD_CURDATE | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR |
SQL_FN_TD_MONTH | SQL_FN_TD_QUARTER | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR |
SQL_FN_TD_CURTIME | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_SECOND |
SQL_FN_TD_DAYNAME | SQL_FN_TD_MONTHNAME
46 SQL_TXN_CAPABLE 2 SQL_TC_ALL
72 SQL_TXN_ISOLATION_OPTION 0x00000002
SQL_TXN_READ_COMMITTED
96 SQL_UNION 0x00000003 SQL_U_UNION |
SQL_U_UNION_ALL
47 SQL_USER_NAME "admin"
10000 SQL_XOPEN_CLI_YEAR "1995"
