Having some trouble connecting a java2 app to my personal oracle 8i db whenever
I specify the db name.
Here are some particulars:
DMBS: Oracle8i Personal Edition rel 8.1.6.0.0
JServer Rel 8.1.6.0.0
JDBC Driver: Oracle JDBC driver 8.1.6.0.0
dB: jdbcracle
ci:@
db_name: First
Running JVM 1.3 and 8i on my windows 98 SE notebook.
This connection statement which uses the default connection for an OCI driver
works:
Connection conn = DriverManager.getConnection ("jdbcracle
ci8:@", "demo",
"demo");
But when I specify the dB name the following connection returns an error
msg:
Connection conn = DriverManager.getConnection ("jdbcracle
ci8:@First",
"demo", "demo");
The error returned is: SQLException: ORA-12541: TNS:no listener
When I try to use the thin driver with the following connection, I also get
an error
Connection conn = DriverManager.getConnection ("jdbcracle:thin:@jd-dell-note:1521:First",
"demo", "demo");
The error returned is: SQLException: Io exception: The Network Adapter could
not establish the connection:null
So, any help you can provide is much appreciated...
Jim.


racle
Reply With Quote


Bookmarks