OO 3.2.1 Base, Windows, Oracle, JDBC

[schusr]

Installed OpenOffice 3.2.1 on a Windows 2003 system.

I want to connect to an Oracle instance using JDBC

JRE 1.6.0_20 is installed and used

Add driver via Tools, Options, Java, Class Path, Add Archive, point to ojdbc6.jar

Then File, New, Database, Connect to JDBC

No matter what I put in the JDBC driver class it does not test successfully.

Most common answer is oracle.jdbc.driver.OracleDriver but does not work.

[dacm]

Okay...I'm posting without doing the research myself but are you sure that Oracle supplies all JDBC services through a single .jar file? Some enterprise-level engines require multiple .jar files for all/specific services. Though normally the driver service is one archive file. Otherwise, make sure the 'oracle.jdbc.driver.OracleDriver' syntax is exactly correct...and check for a space at the end of your string and eliminate it if found.
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'

[schusr]

Readme suggests the new class name is oracle.jdbc.

Attempting to use the Oracle 11.1.0.7.0 driver that downloads as one file ojdbc6.jar.

Can't believe this is a problem.

[schusr]

Oracle readme with the driver has this code snippet

Connection conn =
new oracle.jdbc.OracleDriver().defaultConnection();

So I assume the correct JDBC driver class name is oracle.jdbc.OracleDriver but that does not work

[r4zoli]

I added ojdbc6.jar to the classpath, and it gives:

[dacm]