I have an application that works fine locally and remotely but when ran in our dmz it cannot connect to the database and gives the useless error "The server could not be contacted". On that machine I can use Sql Plus and connect to the database and run queries with no issue. I have tried with both tns and with ip and get the same error.
Most likely its a firewall related issue, but besides port 1521 what ports are needed for this to work? Since Sql Plus works and tnsping resolves correctly I did not expect any problems.
How does this need to be configured to properly going through the firewall? It has to be as strict as possible.
Windows 2008 server, 64bit, 64bit and 32bit oracle drivers installed. Running dotConnect 6.80.350.0
The server could not be contacted
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: The server could not be contacted
We have answered you by e-mail.