BUG: Access ODBC: SQLGetInfo(SQL_NON_NULLABLE_COLUMNS) (120044)
The information in this article applies to:
- Microsoft Open Database Connectivity 1.0
This article was previously published under Q120044
BUG# SQLDBASE: 2131 (1.01.1928)
SYMPTOMS
Calling SQLGetInfo with InfoType=SQL_NON_NULLABLE_COLUMNS for Microsoft
Access ODBC driver returns the value as SQL_NNC_NON_NULL, which implies
that the columns may be non-nullable and that the data source supports the
NOT NULL column constraint in CREATE TABLE statement. However, the
Microsoft Access ODBC driver does not allow NON NULL constraint in the
CREATE TABLE. Therefore, the value returned should be SQL_NNC_NULL to
indicate that all columns must be nullable.
STATUS
Microsoft has confirmed this to be a problem in Access ODBC driver version
1.01.1908. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
| Modification Type: | Major | Last Reviewed: | 7/27/2001 |
|---|
| Keywords: | kbBug KB120044 |
|---|
|