Link to home
Start Free TrialLog in
Avatar of twg
twg

asked on

reading database behind a firewall

Is there any difference in reading data from databases(using jdbc)which are behind a firewall? Do i have to use special tools?
ASKER CERTIFIED SOLUTION
Avatar of comerm
comerm

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ravindra76
Ravindra76

Informative
All a firewall does it block unnecessary ports. And allow ones which are necessary eg port 80 for http.
in my case Sybase woudl be using port 2638.
so its as simple as changing your firewall to allow that port through...
Just find out which port your database communicates with  and allow it through the firewall..
If you have no access to the firewall..
I can't see there is much you can do.
cam rat, this is not completely true... Many firewalls are actually proxy servers - meaning that they stand inbetween client and server and are involved in the protocol. This makes things more complicated.

However, I believe that it is true that all can be configured to allow unrestricted traffic (i.e. no proxy function) on certain ports. Hoewver, then you have to know the ports involved. To make things even worse, some protocols (like FTP for example) initiate connections on a known port, but then spawn other connections on other ports as needed (the FTP control channel versus the data channels.) I am not sure if any of the db vendor's protocols do this.