Can't connect with ODBC from WAN

akrawiec

New Member
I can connect to Progress 9.1E database with ODBC from LAN, but can't connect from WAN workstation.
I configured virtual serwer in firewall/router with right port, but cannot connect to sql broker from WAN.

My database server is Progress 9.1E on Suse 9 Enterprise.
Windows Client: DATADIRECT 4.10 32-bit Progress SQL v9.1E
Port 50990.

When I run Test Connection from LAN, IPTraf (on Suse Linux) shows:
5 Packets Received from LAN Workstation and 5 packets Send From server.
Workstation: "Connection established."

When I test connection from WAN, IPTraf shows:
4 Packets Received from WAN Workstation and 3 packets Send From server.
Workstation: "Error in Network Daemon."

It seems, that broker can't answer after 4-th packet ????

I need help. Can anyone help me?
 
Ok, I found it.
There are additional SQL (and 4GL as well) broker parameters -minport, -maxport.
When I defined them ie. -minport 5100 -maxport 5199, and defined them in firewall as a range 5100-5199 redirected to database server, ODBC connection from WAN started working without any troubles.
 
Back
Top