Re: [libreoffice-users] Base MySQL Native connector problems

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