Hi all, I am trying to links tables in Access 2002 using the MaxDB 7.5 ODBC driver (with a user DSN).
If I set the SQL mode to INTERNAL, I can get a list of tables (and they look right, eg. DBUSER.TableName), but when I try and link it I get: ODBC--call failed [SAP AG][SQLOD32 DLL][MaxDB]Syntax error or access violation;-5015 POS(13) Missing keyword:FROM. (#-5105) The SQLTrace shows it is trying to make the following SQL call: SELECT SCOPE=NUM(1), COLUMN_NAME='SYSKEY', DATA_TYPE=99, TYPE_NAME='CHAR', PRECISION=NUM(8), "LENGTH"=NUM(8), SCALE=NULL, PSEUDO_COLUMN=NUM(2), CODETYPE= 'BYTE' FROM SYSDBA.DUAL WHERE NULL<>NULL With the result: PARSE : CMD : SQLCODE: -5015 Missing keyword:FROM PARSEID: OUTPUT: 00000000 00000000 00000000 00000000 SQLERRD(INDEX_6) : 13 ERROR NEAR ^ : LECT SCOPE^=NUM(1), C START : DATE : 2004-02-20 TIME : 0016:35:38 END : DATE : 2004-02-20 TIME : 0016:35:38 If I throw that SQL command into SQLStudio I get the same error (it doesn't like the =NUM(1) and ='SYSKEY' etc). If I set SQL mode to ANSI, I again get a list of tables, but this time they have odd spaces (eg. "DBUSER _TableName ") and when I try and link the table I get an error that the table name contains invalid punctuation or characters. I've also tried ORACLE and DB2, and I get the same result as INTERNAL. I have tried several different versions of ODBC driver, going back to 7.3.0.17. Also, the ODBC connection works fine from Excel and OpenOffice. Does anyone have any suggestions? I would have thought this should be a fairly common thing to want to do. Cheers Derek Hinchliffe -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
