Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How I JDBC connect Mathematica 5.1 to Oracle 10g?

RE: How I JDBC connect Mathematica 5.1 to Oracle 10g?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 20 May 2005 09:39:46 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0A49F5@MSXVS01.trivadis.com>


Hi=20

>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?

The last time I started Mathematica was in 1991... huh, what a long = time!

><< DatabaseLink`
>OpenSQLConnection[JDBC["oracle.jdbc.driver.OracleDriver", \
>"jdbc:oracle:thin_at_localhost:1521:ORCL"], Username -> "SCOTT", =
"Password" ->=3D
> \
>"TIGER"]
>JDBC::error: "JDBC error: Invalid Oracle URL specified"

A ":" is missing in the connect string, i.e. it should be = "jdbc:oracle:thin:@localhost:1521:ORCL".

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 20 2005 - 03:44:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US