The solidDB ODBC driver has some non-standard behavior and limitations.
Error information
Regardless of the version set by the client, the driver returns error information that is based on the ODBC 3.0 specification.
Error in SQLPutData using SQL_NULL_DATA as parameter length
If you try to insert or update one or more data items where one of the items has SQL_NULL_DATA as the length specifier, no data is inserted and the column value is NULL.
SQLAllocHandle can return incomplete error information
If you call SQLAllocHandle with an invalid handle type, for example:
SQLAllocHandle(-5, hdbc, &hstmt);
the function returns SQL_ERROR but not the error state "HY092" or the message "Invalid Attribute/Option Identifier".
MSAccess - linking the table with certain column types
After linking the table with data types WCHAR, WVARCHAR, and LONG WVARCHAR, when a user inserts a particular record and then inserts, updates, or deletes another record, the driver shows "#deleted" for the previous newly added or updated record.
ActiveX Data Objects (ADO) OpenSchema methods
The following OpenSchema methods are not supported through ADO:
▪ adSchemaCatalogs
▪ adSchemaColumnPrivileges
▪ adSchemaConstraintColumnUsage
▪ adSchemaConstraintTableUsage
▪ adSchemaTableConstraint
▪ adSchemaForeignKeys
▪ adSchemaTablePrivileges
▪ adSchemaViews
▪ adSchemaViewTableUsage
Note These OpenSchema methods are not supported by ADO with any ODBC driver. This is a limitation of the Microsoft OLE DB Provider for ODBC and not specific to the solidDB ODBC Driver.