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

Hello Ian,
I am at loss wondering what is still wrong in your case. You have obviously
added the Java Runtime Environment in LO (I specified the Oracle 1.7.0_03 version),
as well as added the jar-file of the connector under "Class Path" (the jar-file is
selected under "add archives"). For the server I actually specified the host name
(not localhost) because I access the DB also from a client across a LAN.
As I said before, I don't use MyAdmin but only the command-line client (mysql),
so I cannot be of any help there...
Sorry in any case for not coming up with the "magic wand"....
Regards
Heinz

On Thu, 28 Feb 2013 11:06:26 +0100, Ian Whitfield <whitfield@telkomsa.net> wrote:

> On 27/02/13 18:04, Heinrich Stoellinger wrote:
> > Regarding the JDBC-connector:
> > download it from the MySQL homepage, un-tar it, then under LO go into
> > Options -> Extended ("Erweitert" in the German version). There you add
> > a Java Runtime Environment and also specify the directory into which you
> > put the .jar-file of the connector in the class path...
>
> Thanks Heinz
> I got the Connector from MySQL Downloads and did what you suggest,
> un-tarred it into a Folder called /home/SOFTWARE. Went to the Java
> settings in LO and added this path to Class Path.
> (BTW the 1.4.0 setting is at 'Options>Advanced' now).
>
> I then re-started and re-booted the system and went to LO Base -
> Select Connect to existing DB
> Pick 'MySQL'
> Connect using JDBC
> Enter DB Name
> Server localhost
> Port 3306
> Driver class comes up as 'com.mysql.jdbc.Driver so Test Class.
>
> ERROR - "The JDBC driver could not be loaded"
>
> This is on my Test machine - My Work machine will not even load MyAdmin
> still and I can't crack that one either!! I wonder if something has
> changed in the new PCLOS or in LO???
>
> Once again I'm stuck again - any thoughts!!??


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