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

On 04/15/2013 04:31 PM, Dan Lewis wrote:
> 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
Okay.
So, the Native driver only works on 4.x.  So much for that.
I just re-packaged Mysql-connector-java 5.1.18, which LO found, but LO 
needs to be restarted and I don't want to do that until I power up again 
tomorrow.  I have 5 open files and it is a pita closing and reopening 
them.  Yes, I am lazy.  So, the final test will have to wait until tomorrow.
Thanks for the help.
Girvin Herr



--
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