Hello again,
I really appreciate that there is allways someone to propose a
solution.
I went to Tools>Options>Java and selected the class path>add
archive>mysql-connector-java-3.1.10-bin>ok>
Te driver was not installed when I reopenned Tools>Options>Java
I tried Runtime Environment>Add >Program
Files>Java>jre1.5.0_04
Again although it appeared in the list of the installed environments
when I closed the program and I reopened it, it was not on the list
Any suggestions?
Yannis
O/H Andrew Jensen έγραψε:
Παπαδόπουλος
I am not sure if this helps. But I needed to register the jar file for
the JDBC driver with OO.o before I could get the connection to work.
Tools>Options>Java then select the class path button. Now the add
archive button. Browse to the JDBC jar file, and include it.
Hope that helps.
Andrew Jensen
Γιάννης Παπαδόπουλος wrote:
Sorry,
I will try to be more precise. I have used theinstructions in the page "
How to connect to a MYSQL Database via JDBC - Drivers
with StarOffice/OpenOffice.org(Version 1.0.2 or later)"
http://kienlein.com/pages/mysql-jdbc-howto-en.html
1. I chose from Database Wizard "Connect to an existing Database"
-->My Sql
2. Setup a Connection-->Connect using JDBC
3. Setup a connection
a. Name of the Database: press
b. Server Url: jdbc:mysql://localhost/press
c. Port number: 3306
d. My Sql Jdbc driver class: com.mysql.jdbc.Driver
4. User name: root
Password not required
5. Yes register my Database
Open the Database for editing
I save the database with the name Javapress. When I click on the tables
icon I get the message "The connection to the 'Javapress' Datasource
could not be established. The connection to the external Data source
could not be established.An unknown error occured. The driver is
probably defective. I have the last edition of Java installed for Win
Xp.
What shall I do next. Sorry but I don't know a thing about Java,
classes etc. I am just a humanities student, trying to import a
Database. I don't want to use Ms Access and I don't afford to pay a
programmer. It's been more than two weeks that I try to work on this
base. I have managed to use the ODBC driver in a University
computer 2 years ago. I try now to install oo in my own computer.
Yannis
O/H Frank Schönheit - Sun Microsystems Germany έγραψε:
Hello Yannis,
can anyone recommend a step to step guide to JDBC driver for OO2. I
tried to find one, but they are refering to the 1.x editions and the
interface has changed
?
Not sure what interface you're referring to, but if you have an JDBC
driver which works in OOo 1.x, it should also work in 2.0. JDBC is a
generic database access interface which is stable and
downwards-compatible ...
Ciao
Frank
|
