Hi,
this is a follow-up because I got no answers.
Hope on this list are some guys who can play with Oracle?
Syntax ist straightforward.
mDBProperties(0).Name = "User"
mDBProperties(0).Value = "Me"
mDBProperties(1).Name = "Password"
mDBProperties(1).Value = "secret"
mDBProperties(2).Name = "IsPasswordRequired"
mDBProperties(2).Value = True
oDriver = createUNOService("com.sun.star.sdbc.DriverManager")
sDatabaseURL = "jdbc:oracle:thin:@//IP:1521/DBName"
oConnect = oDriver.getConnectionWithInfo(sDatabaseURL,mDBProperties())
Regards
Peter
-------- Original-Nachricht --------
Betreff: [dba-dev] StarBasic: connecting to Oracle via
css.sdbc.DriverManager
Datum: Mon, 19 Sep 2005 11:59:29 +0200
Von: Peter Eberlein <[EMAIL PROTECTED]>
Antwort an: dev@dba.openoffice.org
An: dev@dba.openoffice.org
Hi,
connecting to a non-registered Oracle DB with the DriverManager fails
(Null-object).
As URL I used "jdbc:oracle:thin:@//IP-Address:1521/DatabaseName".
It is no problem to establish the connection manually with one of the
database entries JDBC or Oracle JDBC.
I could also succesfully connect via API with the registered Database
and the DatabaseContext Service.
Connection.MetaData.URL gives me the same URL as mentioned above.
Any hints?
I also tried the Service com.sun.star.comp.sdbc.JDBCDriver with the
JavavDriverClass as Property without success.
Regards
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
