Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> StarOffice >> StarSuite

SO8 Base - how to register JDBC Driver?

I have StarBase 8 running on a windows xp system and want to connect (JDBC) to a MySQL Database on a remote server (via Internet). The "Help" tells me to write the Class Path into java.ini - but I dont find a java.ini besides a java.ini in my old OO o 1.15 folders.

In the Writer's Options window I wrote the location of mm.mysql.2.0.4-bin.jar, but this does not help.

WHERE should the mm.mysql.2.0.4-bin.jar reside?

HOW should I tell this to StarBase?

Richard

By the way, this forum bears the title "StarOffice 6" and I seeked for a StarOffice 8 forum. To avoid this it should be renamed, perhaps omitting the version number. People are puzzled!

[718 byte] By [r_a_mueller1] at [2007-11-25 22:32:50]
«« Readonly access to dBase tables
»» Text size
# 1

Hi r_a_mueller1

Please make sure that the Java class file for the JDBC driver was added to the StarOffice settings. In StarOffice[TM] open the menu "Tools - Options - StarOffice - Java" and click on [Class Path]. In the following dialog click on [Add Archive]. Here add the JAR file of the JDBC driver.

LarsRoesman at 2007-7-5 2:47:55 > top of Java-index,StarOffice,StarSuite...
# 2

Sorry, but your answer does not help me further. _Where_ in StarOffice? I openend the Tools (Extras) dialog in Writer. And the path is written down in the Java section of the Options. That's OK.

Back to the Database assistant:

Datasource-URL: jdbc: <a href="mysql://server.de:3306/database_name" target="_blank">mysql://server.de:3306/database_name</a>

JDBC-Driverclass: mm.mysql-2.0.4-bin.jar

[As mentioned above, the location of mm.mysql-2.0.4-bin.jar is noted in the Java section of the Writer's Options]

Button "Test Class": The JDBC-Driver could not be loaded

Sorry, but I'm not further than before...

Richard

r_a_mueller1 at 2007-7-5 2:47:56 > top of Java-index,StarOffice,StarSuite...
StarSuite

StarOffice New Topic

StarOffice Hot Topic

StarOffice

All Classified