Hi Thomas, Thanks for your reply, at least I know it is being looked at.
In the meantime, is there an earlier 7.5.00 kernel build around that doesn't have the problem (without going back to a SAPDB 7.4 build)? I don't mind downgrading for a bit as I need to do a couple of weeks of testing my solution before anyone else will be using it (but I can't test until I get the ODBC connection working). Cheers Derek > -----Original Message----- > From: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED] > Sent: Friday, 20 February 2004 5:59 PM > To: 'Derek Hinchliffe'; [EMAIL PROTECTED] > Subject: RE: Can't link tabled iin MS Access via ODBC to MaxDB 7.5.0.08 on > Linux > > 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]
