MySQL Forums
Forum List  »  Connector/ODBC

ODBC call failed for linked table, but OK for import?
Posted by: Ian Steer
Date: February 08, 2016 08:52PM

I have a new installation of MySQL (5.7) on Windows 10 and trying to use MS Access 2007 as the front-end (which I have done with earlier versions of MySQL & the ODBC driver). I have MySQL ODBC 5.3 32 bit ANSI driver installed.

When I try to *LINK* to the MySQL table from Access, I get ODBC - Call Failed (but it subsequently shows all the table field names, but no data values).

When I try to *IMPORT* the MySQL table data, all is well.

Anyone have any ideas ?

Ian

Options: ReplyQuote


Subject
Written By
Posted
ODBC call failed for linked table, but OK for import?
February 08, 2016 08:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.