Skip to Content
0
Former Member
Dec 01, 2009 at 04:27 PM

MaxDB ODBC driver for Windows Issues

58 Views

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