I am evaluating MaxDB 7.7 for Windows with my app http://www.zidsoft.com"> CompareData and encountered the following issues when testing the app with the SAMPLE database using the ODBC driver MaxDB 7.07.06.09. Server and client are running on Windows XP 32-bit
For most catalog functions such as SQLTables, SQLForeignKeys, etc the driver returns an error when calling SQLColAttribute with
SQL_DESC_LENGTH, SQL_DESC_SCALE, SQL_DESC_NUM_PREC_RADIX
<pre>
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 1 (PKTABLE_CAT)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 1 (TABLE_CAT)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 10 (ASC_OR_DESC)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 10 (UPDATE_RULE)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 11 (CARDINALITY)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 11 (DELETE_RULE)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 12 (FK_NAME)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 12 (PAGES)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 13 (FILTER_CONDITION)
[Error][SQLColAttribute]Failed to determine column length: SQL_DESC_LENGTH column 13 (PK_NAME)
[Error][SQLColAttribute]SQL_DESC_SCALE column 1 (PKTABLE_CAT)
[Error][SQLColAttribute]SQL_DESC_SCALE column 1 (TABLE_CAT)
[Error][SQLColAttribute]SQL_DESC_SCALE column 10 (ASC_OR_DESC)
[Error][SQLColAttribute]SQL_DESC_SCALE column 10 (UPDATE_RULE)
[Error][SQLColAttribute]SQL_DESC_SCALE column 11 (CARDINALITY)
[Error][SQLColAttribute]SQL_DESC_SCALE column 11 (DELETE_RULE)
[Error][SQLColAttribute]SQL_DESC_SCALE column 12 (FK_NAME)
[Error][SQLColAttribute]SQL_DESC_SCALE column 12 (PAGES)
[Error][SQLColAttribute]SQL_DESC_SCALE column 13 (FILTER_CONDITION)
[Error][SQLColAttribute]SQL_DESC_SCALE column 13 (PK_NAME)
[Error][SQLColAttribute]SQL_DESC_SCALE column 14 (DEFERRABILITY)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 1 (PKTABLE_CAT)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 1 (TABLE_CAT)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 10 (ASC_OR_DESC)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 10 (UPDATE_RULE)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 11 (CARDINALITY)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 11 (DELETE_RULE)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 12 (FK_NAME)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 12 (PAGES)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 13 (FILTER_CONDITION)
[Warning][SQLColAttribute]SQL_DESC_NUM_PREC_RADIX column 13 (PK_NAME)
</pre>
Also for SQLPrimaryKeys the driver says the 'PK_NAME' of the resultset data type is SQL_BINARY, should be varchar per ODBC spec.
I don't remember having any of these issues with the 7.6 driver?
Edited by: farid z on Dec 1, 2009 5:28 PM