Optional Feature Not Implemented

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
BKTraynor
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Optional Feature Not Implemented

Post by BKTraynor »

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.
Last edited by RoryOF on Mon Oct 31, 2016 6:02 pm, edited 1 time in total.
Reason: Corrected typo in Subject [RoryOF, Moderator]
OpenOffice 4.1.3
Windows 10
MySQL 5.7.9 x64
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Optional Feature Not Implemented

Post by Villeroy »

You may find some useful connection parameters under menu:Edit>Database
Can you try the built-in SDBC driver? Choose connection type MySQL instead of ODBC.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
BKTraynor
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Post by BKTraynor »

Thank you Villeroy.
This did not work, but I'll explain what I've done to see if I've made some other error.

Under Edit/Database/Connection Type, I selected
MySQL(ODBC) This tests as a successful connection

Under Tools/Options/OpenOffice Base/Connections, I have been using
com.sun.star.comp.sdbc.ODBCDriver with ODBC

After changing to MySQL(ODBC), this connection also doesn't work.

I then changed to
org.openoffice.comp.drivers.MySQL.Driver and that doesn't work.

I have "Connection Pooling Enabled" [otherwise the menu of drivers is grayed out]

and I have to click "Enable pooling for this driver" in order get that driver to show "Yes" in the Pool column.

I will add that yesterday I found (and lost) a site that said there is a utility where you can check whether MySQL is recognizing my.ini to get configurations.
The reason to check this would be to see if MySQL recognizes the max_allowed_packet=500M.
I couldn't find this utility anywhere in MySQL Workbench.
OpenOffice 4.1.3
Windows 10
MySQL 5.7.9 x64
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Post by robleyd »

If you can pass a single query to mysql, try

Code: Select all

show variables like 'max_allowed_packet'
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
BKTraynor
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Post by BKTraynor »

Thank you Robleyd.

I can do that, and it's 1677216 for max_allowed_packet.

Is there another variable I should look at?

Is there a way to get at exactly which Optional Feature is missing -- an error file or some such?

I'm on Windows 10. Could this be just another Windows 10 problem along with the (probably) thousands of other applications that don't work properly?

BKT
OpenOffice 4.1.3
Windows 10
MySQL 5.7.9 x64
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Post by robleyd »

That suggests the my.ini file isn't being read?

As a first step, try checking the mysql error log which may give a hint about the loading error - https://dev.mysql.com/doc/refman/5.7/en/error-log.html
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Post by robleyd »

That last possibly isn't going to help as you are requesting data from a remote server, but try anyway.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
BKTraynor
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Post by BKTraynor »

I have now looked at the max_allowed_packet variable both on localhost and the server. The server shows a number with no correlation to the 500M I specified, but localhost shows that number.

Localhost has the same error message as the Lunar Pages server. So the remote server has its own parameters that I can't change, but there should be no reason why there would be a problem since the ODBC connection tests successful.

I am going to install all of this on a Windows 7 machine. What I have done is a standard installation of OO and MySQL, and it is not working.

How many thousands of programs and applications does Windows 10 crash after every forced update? I suspect this is one of them. I will report my results.
OpenOffice 4.1.3
Windows 10
MySQL 5.7.9 x64
Post Reply