Hi, I am using MaxDB 7.5 with ODBC Driver 7.5 and I keep getting a "[SQLOD32 DLL] Restricted data type attributes violation (#0)" error when query result contains non-English data (query result with only English data works fine).
The weird thing is that inserting the same data into the database works, and ODBC trace even shows the data coming back in query (see log file below). The problem is not unique to the client application (Microsoft Access and OpenOffice reported the same error) either, so it appears that something in the ODBC layer is not working. I am running Windows XP for both the database server and the client (same box). Microsoft Access 2000 and OpenOffice 1.1 are the clients. Has anyone seen this problem before? Is there a way to fix it? PJ ------------------------------------------------------ PRODUCT : MaxDB C-PreComp Runtime VERSION : 7.5.0 BUILD : 008-123-061-548 DATASOURCE: SAP_UTEST SESSION : 1; SQLMODE : INTERN SERVERDB : UTEST SERVERNODE: lab351 CONNECT "DBA " IDENTIFIED BY :A ISOLATION LEVEL 1 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 SELECT "DBA"."PERSON"."NAME" FROM "DBA"."PERSON" PARSE : CMD : mfIndex init : 1 mfIndex init : 2 PARSEID: OUTPUT: 00000172 00000201 3C002C00 0D000000 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 SELECT "DBA"."PERSON"."NAME" FROM "DBA"."PERSON" EXECUTE: CMD : PARSEID: INPUT : 00000172 00000201 3C002C00 0D000000 mfIndex init : 2 mfIndex init : 2 WARNING: W-------8------- SQLRESULTNAME : SQL_CURSOR_0001 SQLERRD(INDEX_3) : -1 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 MASS STATEMENT : FETCH "SQL_CURSOR_0001" PARSE : CMD : WARNING: W--3------------ PARSEID: OUTPUT: 00000172 00000401 2A002B00 0D000000 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 MASS STATEMENT : FETCH "SQL_CURSOR_0001" EXECUTE: CMD : PARSEID: INPUT : 00000172 00000401 2A002B00 0D000000 PARAMETER DESCRIPTION: 0X081A2510 Application Kernel Nr. Type Length Type Length Fraction --------------------------------------------- 1 42 102 24 50 0 OUTPUT : 1: NAME : ��� <------------------ Japanese data came back SQLERRD(INDEX_3) : 1 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 CLOSE "SQL_CURSOR_0001" PARSE : CMD : PARSEID: OUTPUT: 00000172 00000501 06002800 0D000000 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 CLOSE "SQL_CURSOR_0001" EXECUTE: CMD : PARSEID: INPUT : 00000172 00000501 06002800 0D000000 PARSEID: SELECT: 00000172 00000201 3C002C00 0D000000 mfIndex init : 2 mfIndex restore : 2 START : DATE : 2004-02-13 TIME : 0016:17:16 END : DATE : 2004-02-13 TIME : 0016:17:16 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
