Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


On 04/15/2013 05:53 PM, Girvin Herr wrote:
Greetings,
I am configuring a new Linux system with MySQL 5.5.29 and LibreOffice 3.6.5.2. Since it is a new install, I figured I would try using the MySQL (Native) connector for the first time. However, it did not work. Of the 3 selections {MySQL (JDBC), MySQL (Native), and MySQL (ODBC), I selected the MySQL (Native) option, but when I selected the tables icon and entered my password at the prompt, I got the following:

   The connection to the data source "foobar" could not be established.

   The connection to the external data source could not be established.
   No SDBC driver was found for the given URL.

When I clicked on the more information button, I got:

   SQL Status: HY000

and:

   A connection for the following URL was requested
   "sdbc:mysql:mysqlc:localhost:3306/foobar.

Clearly I have a disconnect. What is this SDBC driver I am being told is missing? Is this SDBC driver going to be any better than the JDBC driver I had been using?

I was under the impression that to use the Native connection, all was supplied with LO and I would not need any other drivers. I can always go back to the mysql-connector-java driver (JDBC), but I was hoping the LO native driver could work better.

Thanks in advance.
Girvin Herr
I have been able to use the AOO version of MySQL Connector 1.0.1 for LO 3.5.x through 3.6.6.2. There seems to be a secrete: you must also install these files: libmysqlclient18 and libmysqlcppconn5. After installing them and MySQL Connector 1.0.1, you should be able to connect to a MySQL Server. One more point, if you have been using JDBC MySQL connector, you must remove it from the Class Path (Tools > Options > LibreOffice > Java > Class Path. This works for me using Ubuntu 12.04 32 and 64 bit. The LO native driver was built with LO 4.0.0 so it will only work for 4.0.0 and above. The previous paragraph is for those who do not want to use 4.0.x until many of the bugs have been eliminated.

--Dan


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.