Hi Derek, > -----Original Message----- > From: Derek Hinchliffe [mailto:[EMAIL PROTECTED] > Sent: Freitag, 20. Februar 2004 09:43 > To: [EMAIL PROTECTED] > Subject: Can't link tabled iin MS Access via ODBC to MaxDB 7.5.0.08 on > Linux > > > 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)
Unfortunately there is an inconsistency between the kernel and the ODBC driver in 7.5.00 build 8. FYI, the kernel tidied up its SQL syntax but the ODBC driver didn't follow quick enough. At the moment you are in the uncomfortable position that you cannot fully access(sic;-) the DB via ODBC. I'm going to provide asap a new driver to fix this problem. As soon as the driver is available I'll send a message to the list. Please apologize this bad situation Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
