JDBC Driver for Open Office Base

[Rivan]

I would like to connect to a MySQL database with OpenOffice Base ( windows version ). So I do " Connect me to existing database "/ MySQL / Next / Login using JDBC ( ODBC because I do not propose to select the URL of the server) / Next. This is the level where my problem arises : When I click " Test class " , I get the message: "Test JDBC driver : Unable to load the JDBC driver). How can I load this driver. Please help ?

[MindSpace]

Configuration with Mandriva 2007.0 ( PWP 2007 , kernel 2.6.17 ) , openOffice.org 2.0.4 , MySQL 5.0.24a
I. Preparation , installation driver
1 ) Download the driver for jdbc
http://www.mysql.com/products/connector/
2) unzip anywhere ( even for your user ), for example in / home / name / mysql - jdbc- driver
3 ) Open OO > Options > OpenOffice.org > Java > Class path> Add an archive .
Choose / home/nom/mysql-jdbc-driver/mysql-connector-java- [ version number ]- bin.jar, ( which saves us the mods described here: and their transcription in bashrc
4) Close OO (it will be necessary to restart ) .

[Zecho]

Check the steps:
1) Launch oobase
2) Connect to an existing database > mysql Choose from the list > next > use jdbc connection
3) From here, you just need the parameters:
- Name of the database
- URL of the server ( in general) : localhost
- port (default ) : 3306
- Name of the mysql user
- Password mysql user
You will then work with OO interface.

[opaper]

These steps are only valid for MySQL connection

1. you obtain the new JDBC driver from www.mysql.com
2. Start OpenOffice.org and open the Options dialog box under Tools > Options. Here , choose Security and press the button Add add files *. Jar Your driver
3. Restart OpenOffice.org
4. Under Tools > Data Sources, open the dialog administrative data sources
5. Press the New data source and enter a valid name as MySQLJDBD and keep the type JDBC.
6. Enter the source URL data mysql : / / host : 3306/NomBdd
7. Select the JDBC tab . Now you must enter the class name of the driver . For the MySQL connector driver , you must write com.mysql.jdbc.Driver. If you use any other driver, you must refer to its manual to insert the correct name of the driver .
8. Now you must enter the username and mark the checkbox if you need a password
9. To be sure that your settings will be saved , press the button Apply
10. To test that you can connect to MySQL , click the tab Tables.

[Reegan]

If you can not connect to the database ( Connection refused ), set the configuration mysql
1) Open as root / etc / my.cnf ( the mysql configuration file in a text editor , NOT a word processor !) and comment the line
skip -networking with a #: # skip -networking
2) / etc / init.d / mysqld restart, mysql is now configured.

[Modifier]

Drivers converts JDBC calls directly into a network protocol operating by the DBMS. These drivers directly encapsulate the client interface and the DBMS are provided by the publishers database . This solution is advocated as part of an intranet. Currently , the databases have virtually all of an ODBC driver, since many of them have been developed interfaces from Microsoft .