Connecting to MySQL with OpenOffice Base using JDBC

[scottie2212]

Hi Folks,

Has anyone here managed to successfully set up a connection between OpenOffice Base and Webhostings MySQL server using JDBC?

After pulling my hair out for a couple of hours last night I finally got a successful connection and updated a record on the server.

I'm now totally bald as I've spent another three hours trying to do it again and can't get it to work. I don't think anything has changed in my set-up but I tried so many things last night I can't be certain.

Specifics...
OpenOffice.org 3.1 installed on Windows XP Pro.
JDBC downloaded from Sun - mysql-connector-java-5.1.8-bin.jar loaded and working.
My internet IP has been enabled through cPanel for remote mysql access and confirmed through information_schema.
I have tried connecting using url and server IP on port 2086 and 2087.

Now, whever I try to verify a connection OpenOffice 'hangs' (Not Responding) and I have to quit to get out of it.

So, if any of you good people can point me in the right direction I'd be most grateful.

TIA,

Scottie.

[MOORE]

Hi,

Obtain mysql-connector-odbc from the MySQL website and install it on your system. Then:

1) Navigate to Control Panel > Administrative Tools and double-click on Data Sources (ODBC)
2) on the User DSN tab Click Add button and from the list of available drivers, select the MySQL ODBC Driver, and click OK.
3) Input requires data in the appeared dialog:

Data Source Name: it's optional. Let it be "Mysql-test" in our case.
Description: is optional as well.

Server: localhost (in case mysql server is installed on the local machine, or IP Address if it's on network machine)

fill out user and password fields respectively. You should be able to see mysql databases under Database drop-down list, choose one. Click OK.


Then, Establishing connection by Creating New Base file:

1) File > New > Database
2) Click on the radio button Connect to an existing database and choose MySQL from the dropdown menu. Click on Next.
3) In the next dialog, you should accept the default choice of Connect using ODBC, and then click on Next.
4) Click Browse and select created connection ([MySQL-test] should be in the list in our case) and next.
5) then enter username and Finish. Save file.
source : wikipedia