Optional Feature Not Implemented
Posted: Mon Oct 31, 2016 5:23 pm
Windows 10
MySQL 5.7.9
OO 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
About the only thing I could find with Google is that this could relate to the max_allowed_packet=4M located in the C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
file. I changed this (as suggested) to 500M, but this doesn't work.
This error message is clearly fatal to any attempt to use Base. Any suggestions appreciated.
MySQL 5.7.9
OO 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
About the only thing I could find with Google is that this could relate to the max_allowed_packet=4M located in the C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
file. I changed this (as suggested) to 500M, but this doesn't work.
This error message is clearly fatal to any attempt to use Base. Any suggestions appreciated.