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 <[email protected]> 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: [email protected] 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
