Salesforce

What Type of Database Connection is possible from Client to Server when the Progress versions differ

« Go Back

Information

 
TitleWhat Type of Database Connection is possible from Client to Server when the Progress versions differ
URL NameP132
Article Number000148669
EnvironmentProduct: Progress
Product: OpenEdge
Version: All supported versions
OS: All Supported Operating Systems
Question/Problem Description
What Type of Database connection is possible from Client to Server when the Progress versions differ?
What OpenEdge versions are compatible using a shared memory connection?
What Progress versions are compatible using a Client/Server connection?
What are the Client/Server version compatibility rules?
What are the database connectivity rules between different OpenEdge releases ?
What are the version compatibility rules between Client and database Server?
Is Progress backwards compatible between releases?
Is there forward compatibility between Progress/OpenEdge versions?
Can a 9.1E Client connect a OpenEdge 10 database?
Can a 10.2B Query/Results Client connect a OpenEdge 9.1E database?
Can a OpenEdge 11 database be connected by a prior version of Client?
Can a OpenEdge 10 database be connected by a Progress 9.1E Client?
Can a OpenEdge 10 database be connected by a later version of Client?
Can a Progress 9.1E Client connect to an OpenEdge Database Server?
Can a higher Progress Client version connect to a lower version Progress database?
Will a lower version Progress Client connect to a higher Progress database version?
Will a minor version Client connect to a different Major version of a database?
Will a version 10 Client connect to a version 9 database?
Will different versions between Client and Database Server connect to each other?
Can an 11.3 client connect to an 11.4 database?
Steps to Reproduce
Clarifying Information

 
Error Message
Defect Number
Enhancement Number
Cause
Resolution

Self-service Connectivity
A client may connect to a database in self-service mode using shared memory only when the client's version exactly matches the database server's version.

Example:
Client is version 11.3.2
Server is version 11.3.2

If the Major and Minor release numbers are the same for the client and the database then the client can make a single user direct connect to the database (i.e. no server is running for the database) and either a self-service or client/server connection  to a running database (i.e the database has been started for multi-user access)

If the client and server have different version numbers (including any of: Major, Minor, Maintenance, and Patch) and a server is running on the database, then the client must connect client/server.
That is, the server must be started with the -S parameter and the client must use -H <hostname or IP address>, -S <servicename or portnumber>  as part of its connect statement or client connection parameters.

Example:
mpro <dbname> -H <hostname> -S <servicename>
prowin32 <dbname> -H <hostname> -S <servicename>
CONNECT -db <dbname> -ld <ldbname> -H <hostname> -S <servicename>


Client/Server Connectivity
Clients are able to connect to Database Servers using Client/Server within the same Major release and 1 Major release prior.

Example 1:
A version 9.1E client can connect client/server to:
Any version 9.1x database server (same major release)
Any version 9.0x database server (same major release)
Any version 8.3x database server (1 major release prior)

Example 2:
A version 9.0B client can connect client/server to:
Any version 9.1x database server (same major release)
Any version 9.0x database server (same major release)
Any version 8.3x database server (1 major release prior)

Example 3:
A version 10.1x or 10.2x client can connect client/server to:
Any version 10.2x database server (same major release)
Any version 10.1x database server (same major release)
Any version 10.0x database server (same major release)
Any version 9.1x database server (1 major release prior)

Example 4:
A version 11.3 client can connect client/server to:
Any version 11.x database server (same major release)
Any version 10.2x database server (1 release prior)
Any version 10.1x database server (1 release prior)
Any version 10.0x database server (1  release prior)

Example 5:
A version 11 client CANNOT connect to version 9 database server  (2 major releases EARLIER).
A version 10x client CANNOT connect to version 8 database server  (2 major releases EARLIER).
A version 10x client CANNOT connect to OpenEdge 11.x database server  (1 major release LATER).
A version 9.1x client CANNOT connect to an OpenEdge 10.x database server  (1 major release LATER).
A version 8.3E client CANNOT connect to a version 9.x database server (1 major release LATER).

Despite the fact that such connection configuration are supported, it is recommended to use the same version client to connect to the same version database server if the full functionality is expected.
 
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:29 AM

Powered by