Problem with Connection Manager.

First not to waste anyone's' time I am attempting to write java applets for the following situation:

1. Oracle8 server running on AIX 4.2.
2. NT web server (Netscape Enterprise).
3. Developing Java applets using Symantec Visual Cafe PDE.
4. I have the class111.zip from Oracle.

I am running my applet in my visual cafe environment. I can connect to the database if I use the direct method.

DriveManager.getConnection(usr/pass_at_orasid ect....) the usual way.

This is OK but the final applet will not work on the web server.
(Database and Web Server must be the same machine.)

So several days of research(Mostly socializing with co-workers) and I discover that oracle has something called Oracle Connection Manager. OK. I used the example code provided by Oracle to use Connection Manager
(check your ORA_HOME/jdbc/samples/jdbctest.java) and I keep getting the
error "Connection Refused" or "Refused"

I guessed that these error messages came from somewhere deep inside java.sql.* or class111.zip and not the "Oracle Connection Manager". Oracle tends to have nice errors. ORA-?????.

I though the Connection Manager I setup on the Web Server may not have been working properly. So I setup an Oracle client and tried to connect to the database using the "Connection Manager". I got error ORA-12204
(..Refused...).

I am guessing that the Connection Manager is not running properly. Does anyone have a GOOD example of an CMAN.ORA file or any other file that may help.

Thanks in advance eh. Received on Fri Dec 18 1998 - 22:19:37 CST