How I JDBC connect Mathematica 5.1 to Oracle 10g?

From: mr SunnyGuy <sunnyguy11_at_gmail.com>
Date: Fri, 20 May 2005 00:26:23 -0700
Message-ID: <99c0eae505052000263af7abf0@mail.gmail.com>

Hi,

Any of you Oracle-L people use Mathematica 5.1?

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 from a Mathematica notebook-interface:

<< DatabaseLink`
OpenSQLConnection[JDBC["oracle.jdbc.driver.OracleDriver", \
"jdbc:oracle:thin_at_localhost:1521:ORCL"], Username -> "SCOTT", "Password" ->=
\
"TIGER"]

JDBC::error: "JDBC error: Invalid Oracle URL specified"

The 10g DB is on my OS X Mac.

I have some other Java tools on my Mac and they connect to 10g with no prob= lem.

Thanks,

-msg

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 20 2005 - 03:31:13 CDT