Optional Feature Not Implemented

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Optional Feature Not Implemented

Postby BKTraynor » 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.
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
BKTraynor
 
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Postby Villeroy » Mon Oct 31, 2016 6:20 pm

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 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24399
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Optional Feature Not Implemented

Postby BKTraynor » Mon Oct 31, 2016 7:38 pm

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
BKTraynor
 
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Postby robleyd » Tue Nov 01, 2016 1:46 am

If you can pass a single query to mysql, try

Code: Select all   Expand viewCollapse view
show variables like 'max_allowed_packet'
Cheers
David
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 944
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Postby BKTraynor » Tue Nov 01, 2016 5:58 pm

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
BKTraynor
 
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm

Re: Optional Feature Not Implemented

Postby robleyd » Wed Nov 02, 2016 2:04 am

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
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 944
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Postby robleyd » Wed Nov 02, 2016 2:23 am

That last possibly isn't going to help as you are requesting data from a remote server, but try anyway.
Cheers
David
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 944
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Optional Feature Not Implemented

Postby BKTraynor » Thu Nov 03, 2016 10:19 pm

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
BKTraynor
 
Posts: 4
Joined: Mon Oct 31, 2016 4:38 pm


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest