Could not establish connection to Oracle 9i

[Mingwei Jiang]

Dear all,

I met a database connection problem. I'm doing a project offshore, and it's fine while I try to connect to the Oracle 9i database here. But when deliver the code to the on site to have a test. It gives me a

  java.sql.SQLException: Io exception: The Network Adapter could not establish the connection  

And I've asked the on site to use other tools to test the connectivity first. It works fine, but using the java JDBC, it gives me such exception. I ensure the parameters are configured properly except I use IP address of the server at offshore, but they configured the server name on site.

[Debopam Poddar]

Just chk whether ports are open from offshore or not!!!

[Chengwei Lee]

Check for firewall issues. The database server should be behind a firewall, normally.