[Date Index] [Thread Index] [Author Index]

Re: Mathematica 5.1 and Oracle 10g

• To: mathgroup at smc.vnet.net
• Subject: [mg57241] Re: Mathematica 5.1 and Oracle 10g
• From: "Drago Ganic" <drago.ganic at in2.hr>
• Date: Sat, 21 May 2005 02:41:06 -0400 (EDT)
• References: <d6k97n$un$1@smc.vnet.net>
• Sender: owner-wri-mathgroup at wolfram.com

I had the same problem. I used the "Oci" driver instead of the "thin" driver 
and now everything is working. It seems there is a problem with the thin 
driver.

Greetings from Croatia,
Drago Ganic


<SunnyGuy11 at gmail.com> wrote in message news:d6k97n$un$1 at smc.vnet.net...
> Hi,
>
> Do you know of any tricks or tips to establish
> a JDBC connection between Mathematica 5.1 and Oracle 10g?
>
> I tinkered with my setup for a couple hours and
> could not get the connection to take.
>
> Screen dump:
> << DatabaseLink`
> OpenSQLConnection[JDBC["oracle.jdbc.driver.OracleDriver", \
> "jdbc:oracle:thin@localhost:1521:ORCL"], Username -> "SCOTT",
> "Password" -> \
> "TIGER"]
> JDBC::error: "JDBC error: Invalid Oracle URL specified"
>
> I have some other Java tools on my Mac and they connect no problem.
>
> -msg
>