Hello folks:
Hope I'm not repeating an old question, but a search for "Oracle Connection" didn't seem to bring up anything that helped.
I'm learning WSAD 5.0 I'm trying to build a connection to a database. I can verify the userID, password etc by connecting to it via SQLPlus. A TNS Ping shows this:
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=128.1.147.12)(PORT=1521))
OK (280 msec)
I'm in WSAD in a data perspective. I right click on the DB Servers window and select "New Connection". In the resulting dialog box I enter the following data:
Connection Name : Web Rates Connection
Database: OIRWE.WORLD
User : a valid user name
Password: a valid password for that user
Database vendor type: Oracle8i, v8.1.7
Now we have two versions of what I've tried
Version 1
JDBC Driver : Oracle THIN JDBC Driver
Host: 128.1.147.12
Port: 1521
Class Location : C:\oracle\ora81\jdbc\lib\classes12.zip
I try to connect and I get an error message that goes beyond what I can see in the pop-up message box. What I can see is:
IWAS0126E Problems encountered while trying to establish connection Web
Rates Connection. Reason: "Io exception: Connection
refused (DESCTIPTION=(TMP=)(VSNNUM=135296000)(ERR=12505)(ERROR_
and that's as much as I can see.
Version 2:
JDBC Driver : Other Oracle Driver
JDBC driver class : oracle.jdbc.driver.OracleDriver
Class Location : C:\oracle\ora81\jdbc\lib\classes12.zip
Connection URL : jdbc
racle:thin:@128.1.147.12:1521
IRWE
Clicking the "Finish" button gives the error:
IWAS0126E Problems encountered while trying to establish connection Web
Rates Connection. Reason: "Problems encountered while loading the jdbc
driver.
Reason: "jdbc.oracle.driver.OracleDriver"
Opening up the C:\oracle\ora81\jdbc\lib\classes12.zip file in WinZip shows that the class file does exist in that package name.
I'm running out of things to try. Does anyone have any ideas what I'm doing wrong?
Thank you.
Greg
