Salesforce

Does a Personal Database accept remote connections?

« Go Back

Information

 
TitleDoes a Personal Database accept remote connections?
URL NameP69991
Article Number000156841
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Does a Personal Database accept remote connections?
Can a client connect to a Personal Database with the -H -S parameters?
Can a client connect to a Personal Database Client Server?
Can a client connect to a Personal Database from a remote machine?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
A Personal Database license is included in all Progress OpenEdge development products (ProVision, OpenEdge Studio, etc.)

It is possible for a client connect to a Personal Database Client-Server if remote is considered as a connection using a port on the same machine.

In order to allow client-server connections to a Personal Database:
  • The Personal Database needs to be started using a "-S <port>" and (specifically) -H localhost.
  • Port ranges are not available to Personal Databases (-minport -maxport)
  • Clients on the local machine can then connect to the Personal Database via that port and localhost (loopback) for the server.
  • Using the actual hostname or IP address will not work for the client connection. 
  • Clients cannot connect remotely from another machine.
Example: Connecting Client-Server to a Personal Database

1.   Start the Personal Database:

$  proserve dbname -S 6767 -H localhost .. message: This server is licensed for local logins only. (4393)
Same message if started with the actual hostname or IP address. The IP bound to the port is 127.0.0.1 (loopback) in each case.

2.   Local Clients connect client-server:

$   prowin32 dbname -S 6767 -H localhost 
$   mpro dbname -S 6767 -H localhost 


prowin32 or mpro will fail if they use the actual hostname or IP address even though they are running on the same box.


 
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:37 AM

Powered by