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

From: mr SunnyGuy <sunnyguy11_at_gmail.com>
Date: Fri, 20 May 2005 01:02:03 -0700
Message-ID: <99c0eae5050520010213fd85db@mail.gmail.com>

yes,

I sense...
progress.

I'm getting a different error now but I think I'm getting closer.

I did check that both my db and lsnr are up.

Also I connected with Jdeveloper and oemapp console just to make sure both the DB and TNS are healty.

Now I see this:
OpenSQLConnection[JDBC["oracle.jdbc.driver.OracleDriver", \ "jdbc:oracle:thin:@localhost:1521:ORCL"], Username -> "

    SCOTT", "Password" -> "TIGER"]

JDBC::error: JDBC error: Io exception: Socket is not connected

Any more trouble shooting hints or tips?

-msg

On 5/20/05, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:

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

>=20

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

>=20

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

>=20

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

> HTH
> Chris

>=20
>=20

>

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

Received on Fri May 20 2005 - 04:07:01 CDT