Error Message When connecting over a VPN

[Caledonian]

We have a new remote location that we are using a VPN to connect to our main office Progress DB. All seems to be fine, but when we run the application we constantly get error messages like:

Error occurred while accessing component property/method: Open.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error code: 0x80020009 ADODB_OpenConnection rtsyscodes.p (5890)

We are running progress 9.1D SP9

Can anyone suggest a fix for this, or even a place to start hunting?

 

[MaximMonin]

it seems some ports blocked by firewall.

 

[RealHeavyDude]

You dont' tell us anything about the software products you are using nor the operating system you are running on. Do you try to connect to a Progress database via ODBC/JDBC or is it that you are trying to connect a Progress DataServer for MS SQL Server?

Anyway, Progress 9.1d is long outdated ( almost 10 years old software ) and most important, it's unsupported by Progress. You should upgrade as soon as possible if there is any value in the application you're running.


Heavy Regards, RealHeavyDude.

 

[Caledonian]

We are using XP Pro on the client and Server 2003 for the server. The software is a Small UK company called Options Mail Order, it uses progress for the client as well as the DB.

Could you suggest what ports progress needs to be opened that might be causing this?

 

[MaximMonin]

Here is official progress document
http://communities.progress.com/pcom/docs/DOC-104551
It describes how deploy application on amazon cloud. Part 2, pages 6-7 have port list to open.

I am not sure about 9 progress.

 

[RealHeavyDude]

Still I don't understand the error message you get.

But, there is no default port a Progress database uses - and it depends how the database is started where you need to look for the ports. Usually the database is either started via a script or with the AdminServer.

If the database is started via a script you need to have a look into the script and the -S parameter. It is either the IP port or service name of the database broker ( which is listening for connections ). Additionally the broker spawns remote servers to which the clients connect. So these ports are relevant too. There is a -minport and -maxport setting which defines the range of IP ports the broker uses to spawn remote servers. If they are not set then the broker just takes the next free IP port.

If the database is started with the AdminServer you need to look in the conmgr.properties and the corresponding server group.


Heavy Regards, RealHeavyDude.