Re: [libreoffice-users] Connecting LO Base to an SQL DB

Hello Ian,
Just one question: the "native" MySQL-Connector should be included in
3.6.2. I had a lot of trouble in the past with it, but now it seems to be
the best choice of all the possible connectors (Native, ODBC, JDBC).
In any case, reading through your steps - I think that
- the database name should be the name of the database as defined in the
  create database statement of MySQL
- did you specify the correct path for the jdbc-connector?
Regards (from snowed-in Salzburg)
Heinz

On Wed, 31 Oct 2012 14:48:42 +0100, Ian Whitfield <whitfield@telkomsa.net> wrote:

> Hi AlL,
>
> Am trying to use Base with a MySQL Database and need help please.
>
> OpSys - PCLinux 2012-6 KDE
> LO - Version 3.6.2.2
> My SQL is installed and running.
> MyAdmin is installed (and I have created an empty Database with this)
> MySQL connector - Downloaded 'mysql-connector-java-5.1.22'
> Restarted LO then Started Base
> Select 'Connect to existing Database' - MySQL
> Accept 'Connect using JDBC'
> Database Name - I entered 'path and file name'
> Server - localhost (everything is on the local computer)
> Port No - 3306
> Driver Class - accept 'com.mysql.jdbc.Driver'
> Test Class
> *ERROR* - The JDBC driver could not be loaded.
>
> The Wiki says /"You can find the correct class name in the documentation
> that came with the driver. MySQL java connector archive version 5.1.6
> contains connector-j.pdf document with description in subdirectory docs.
> The class name is *com.mysql.jdbc.Driver* for version 5.1.6."/
>
> But there are NO pdf files in the Folder!!
>
> Can anyone confirm that my steps are correct and give me details on how
> to cure the error please?
>
> Thanks a lot
>
> IanW
> Pretoria SA.


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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