Instead of using RMI to connect an
applet to a remote database, my dba installed Oracle Connection Manager on the web host, and I am now trying to connect to it from the applet as described at
Cman.
Here is my connection
string:
Where webhost, dbhost, mydomain have been replaced with values specific to my company.
When ever the applet attempts to connect to the database, I get a
error, with error code 12504. As I understand it, this error code means that I didn't supply the sid as part of my connection string.
According to the
oracle documentation on the configuration syntax, it's this:
For the SRV parameter, it goes on to say:
SRV: Specify database service name of the Oracle9i or Oracle8i database... or Oracle System Identifier (SID) value of the pre-release 8.1 database
We are using Oracle8i, so we specified the service name. Our service name is the name of the webhost followed by a hyphen followed by the sid, so webhost-testdb. In addition to the connection string above, I have also tried the following connect_data values:
Any suggestions would be appreciated.
Deb