Help connecting JDeveloper 3.0 to Oracle8i through JDBC

[Quoted] [Quoted] This may be a simple question to most of you, but anyway. I just got [Quoted] JDeveloper 3.0 and wanted to connect it to Oracle8i, running on another machine on the network. My own NT Workstation have the Oracle8i Client installed, and I have set up a Net Service Name for the server at TCP/IP address 192.168.1.1, port 1521, called "ORACLE8I.IKASTHS.DK". The Net Service Name is tested using Net8 Assistant, and there doesn't seem to be [Quoted] [Quoted] any problems here. I have also tested with SQL*Plus, and no problems here neither.

[Quoted] [Quoted] I try to establish a connection by right-clicking on "Connections..." in JDeveloper, which brings up the Connections dialog. I now want to establish [Quoted] [Quoted] a connection to the server with either the JDBC Thin Driver or the OCI8 JDBC [Quoted] Driver. But none of them seems to work. Here's what happens:

[Quoted] I choose "Existing TSN Names", and choose the one, that I created previously, "ORACLE8I.IKASTHS.DK", which is listed here.

JDBC Thin: When I attempt to test the the connection, I get an error that [Quoted] [Quoted] starts with "Connection refused" and a lot of trace information, which somewhere says something about "ERRCODE=12505". I looked this error up in [Quoted] the documentation, which said something about "TNS:Listener could not [Quoted] resolve SID given in connect descriptor". But I don't know what to make of [Quoted] this error. As I mentioned before, everything works fine except in JDeveloper.

[Quoted] OCI JDBC: Here I get a (maybe) more useful error. "No oci8jdbc (or something [Quoted] [Quoted] like that) in java.library.path". But what is "java.library.path", and where [Quoted] are the OCI JDBC drivers located? I assume it's all installed together with [Quoted] JDeveloper, since I checked an option saying "JDBC Drivers". [Quoted] "java.library.path" sounds like a Java classpath, but where do I set it up? [Quoted] In CLASSPATH or in some config file??

[Quoted] Any help with any or both of these questions would be greatly appreciated!

[Quoted] Thanks in advance!

Jacob

jacmads_at_hotmail.com Received on Thu Nov 25 1999 - 11:19:27 CET