MySQL Forums
Forum List  »  Connector/ODBC

Optional Featrue Not Implemented
Posted by: BK Traynor
Date: November 01, 2016 03:12PM

Windows 10
MySQL 5.7.9
MySQL ODBC Driver 3.51 32-bit
OpenOffoce 4.1.3
JRE 1.8.0_73 Installed

I have a good ODBC connection to a MySQL database on a remote server at Lunar Pages.
The connection works perfectly using MS Access 2K.

Opening up Base, I can "see" the database with all the tables listed.

Attempts to retrieve data by Linking to a list box or simply clicking on any of the tables gets this error message:

The Data Content Could Not Be Loaded
[MySQL][ODBC Driver][mysqld-5.6.27-75.0]Optional feature not implemented.

But if I create a SQL query to retrieve only one column, it works.

So I presume that an ODBC connection through OpenOffice needs "something else" that is either unnecessary or native in MS Access.

If you click "More" to learn about the error, you see:
SQL Status: HYC00
Error Code: 537

So the questions are: What optional feature? And how do I implement it?

Could this be related to Windows 10?

I've put these same questions to the OpenOffice forum, so far without success.

Any suggestions appreciated.

Options: ReplyQuote

Written By
Optional Featrue Not Implemented
November 01, 2016 03:12PM

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.