*From*: mr SunnyGuy <sunnyguy11@xxxxxxxxx>*To*: Oracle-L@xxxxxxxxxxxxx*Date*: Fri, 20 May 2005 01:02:03 -0700

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@xxxxxxxxxxxx> 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@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

**References**:**RE: How I JDBC connect Mathematica 5.1 to Oracle 10g?***From:*Christian Antognini

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