Coldfusion 7 connection problem

[rabi]

Hi all,

I am new to CF and trying to establish connection to oracle database
and I am getting following error

# Connection verification failed for data source: usr1
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


CF (Enterprise edition) is hosted onSun Solaris box(V9) . I can
connect to oracle database running on the same machine but the one
that I am trying to connect is a different box (Sun Soalris 10, Oracle
9).

Any help or guidance will be greatly appreciated.

Thanks

[Jacob Munson]

rabi,

In the past I have had to make sure there is an Oracle client installed on the ColdFusion server before CF can talk to the remote Oracle server.  That may not be the case for you though, I think in some cases ColdFusion's builtin stuff does the trick.

Jake Munson
Kuna, ID, USA
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/

[Philip Kaplan]

Try using telnet to connect to the Oracle port and see if you can make a successful connection. If you can't, then perhaps you have a network/firewall issue or Oracle is configured on a different port.