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 >