Re: oracle jdbc abd OpenOffice 2.0 (solved)

From: Harald Finster <hfinster_at_gmx.de>
Date: Wed, 09 Nov 2005 09:02:07 +0100
Message-ID: <4371ACFF.3070309@gmx.de>

Hi,

just want to let you know, that I finally solved the problem. Instead of using "JDBC ORacle" I just used "JDBC" and entered the following into the form:

DATABASE-URL: jdbc: oracle:oci8:@
JDCC-Driver Class: oracle.jdbc.driver.OracleDriver

However, I am wondering, how the system knows, that I want to connect to 'db1'?

Greetings and thanks to all

Harald

Harald Finster wrote:

>> Hi. The driver and it's exception are telling you pretty much
>> what the problem is. Try this URL:
>>
>> String databaseURL = "jdbc:oracle:oci8:localhost:1521:db1";
>>

>
> I tried this and still got
> "Invalid connection string, a valid format is host:port:sid"
>
> As I assume, the information entered in the form (databasename,
> URL and port) is concatenated by OpenOffice to form the
> connection string, I also tried:
>
> Name of Database: db1
> URL: jdbc:oracle:oci8:localhost
> Port: 1521
>
> and still got the same 'result'.
>
> Kind regards
>
> Harald
Received on Wed Nov 09 2005 - 02:02:07 CST