Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <5062E2AF.4080201@hdsnet.hu>
Date: Wed, 26 Sep 2012 13:10:39 +0200
From: =?ISO-8859-1?Q?Reizinger_Zolt=E1n?= <zreizinger@hdsnet.hu>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
To: ooo-users@incubator.apache.org
Subject: Re: Connecting to MySQL problem.
References: <5062DD1C.3070404@telkomsa.net>
In-Reply-To: <5062DD1C.3070404@telkomsa.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

2012.09.26. 12:46 keltez�ssel, Ian Whitfield �rta:
> Hi All - Can anyone help me out please!!??
>
> I want to transfer my Database from the embedded DB to a MySQL DB. I'm 
> using PCLinuxOS 2012 and AOO 3.4.0.
Follow this, for creation database connection:
http://wiki.openoffice.org/wiki/Connect_MySQLandBase

Creation of database structure and data input, use MySQL tools, such 
MySQL Workbench, not tha AOO Base.
Zoltan
>
>  * I Created a new empty SQL DB on my WebServer, with all my fields,
>    using phpMySQLAdmin.
>  * I exported this DB back to my home computer. It comes out as a
>    'filename.sql' and seems to be a text document. (If I "open" this
>    file it opens in my HTML Editor!!)
>  * I downloaded and extracted 'mysql-connector-java-5.1.22.tar.gz'.
>    After extraction I have 'mysql-connector-java-5.1.22-bin.jar' in a
>    folder '/home/ian/Database'.
>  * I have MySQL loaded and the service IS running. (Checked with
>    Control Center)
>  * I DO have Java installed with Office (Sun Microsystems 1.6.0_21)
>  * I start Base and select 'Connect to existing DB' - JDBC
>  * Under Datasource I select the above 'Filename.sql' file.
>  * Under JDBC Class I select
>    '/home/ian/Database/mysql-connector-java-5.1.22-bin.jar'
>  * I select 'Test Class' and get the error "The JDBC Driver could not
>    be loaded".
>
> Where is the problem and how do I get round it??
>
> My requirements are a single user on a single machine!!
>
> Also what other problems am I likely to come across as I proceed?
>
> Thanks for any help.
>
> IanW
> Pretoria SA
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org