SQL Client Access Licensing

Posted by mlungu on 03-Mar-2020 05:49

Progress newbie with a quick question around 10.2b licensing.

I need to connect to older version of Progress 10.2b via odbc.
Databases are all 32 bit versions with relevent client licenses.
However, can I download and use the 64 bit version of SQL Client Access product and setup a 64 bit ODBC connection?

Documentation on ESD refers to a free download but our IT team has indicated we can only use the 32 bit and would have to purchase 64 bit licenses?

Thanks
Kern

Posted by Ruben Dröge on 03-Mar-2020 12:18

OpenEdge 10.2B SQL Client Access is available for download on ESD and is specifically meant for configurations where you want to install an ODBC driver on a different machine than the database server. You should be able to download it for all sorts of platforms using ESD and the serial numbers and control numbers will be published there as well.

You would typically install the 64-bit version of the SQL Client Access products if you have 64-bit clients (i.e. Excel) that will use the ODBC connection.

The fact that the database server is a 64-bit or 32-bit install has nothing to do with it.

The SQL Client Access product download page on ESD also has the following section (with regards to the licensing):

Configuration Examples:

1. OpenEdge SQL Client Access is on Windows and the database server is IBM AIX. Order and install OpenEdge RDBMS for IBM AIX and download and install SQL Client Access for Windows.

2. You have deployed an installation of 50 Registered Client licenses of the OpenEdge RDBMS, with 40 SQL Client Access components. You need 10 additional ones. You or your end-user can download additional SQL Client Access components as required. Note that you cannot exceed the Registered Client counts for which you have licensed the RDBMS.

KnowledgeBase articles:

All Replies

Posted by Ruben Dröge on 03-Mar-2020 12:18

OpenEdge 10.2B SQL Client Access is available for download on ESD and is specifically meant for configurations where you want to install an ODBC driver on a different machine than the database server. You should be able to download it for all sorts of platforms using ESD and the serial numbers and control numbers will be published there as well.

You would typically install the 64-bit version of the SQL Client Access products if you have 64-bit clients (i.e. Excel) that will use the ODBC connection.

The fact that the database server is a 64-bit or 32-bit install has nothing to do with it.

The SQL Client Access product download page on ESD also has the following section (with regards to the licensing):

Configuration Examples:

1. OpenEdge SQL Client Access is on Windows and the database server is IBM AIX. Order and install OpenEdge RDBMS for IBM AIX and download and install SQL Client Access for Windows.

2. You have deployed an installation of 50 Registered Client licenses of the OpenEdge RDBMS, with 40 SQL Client Access components. You need 10 additional ones. You or your end-user can download additional SQL Client Access components as required. Note that you cannot exceed the Registered Client counts for which you have licensed the RDBMS.

KnowledgeBase articles:

This thread is closed