coldfusion Oracle Data Source failure
439064Feb 24 2005 — edited Feb 28 2006I've been on this problem for weeks now. I have searched the net and read manuals untill I'm blue in the face.
I am trying to set up coldfusionmx7 to talk to oracle91
I successfully installed coldfusionmx7 on the same Solaris9 unix box that Apache 1.3 and oracle91 are on.
I configured Apache for coldfusion via the coldfusion installation program. All is fine until I try to configure a Data Source from within the administrator page for coldfusion.
The datasource is Oracle and filled out like this:
------------------------------------------------------------------
CF Data Source Name oracle
SID Name <the sid of my oracle instance>
Server <ip address of unix machine> Port 1521
Username <oracle-user-username>
Password (16-character limit) password for the oracle-user-username
Description oracle
--------------------------------------------------------------------------------------
the error I get is this:
--------------------------------------------------------------------------------------
Connection verification failed for data source: oracle
java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Error establishing socket. Connection refused
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Error establishing socket. Connection refused
--------------------------------------------------------------------------------------
Has anyone seen this before? Any suggestions?