How to install Progress OpenEdge ODBC drivers

Introduction

When using the WebClient, Progress OpenEdge ODBC drivers are not installed on the client pc. The Excel Add-In uses Progress OpenEdge ODBC drivers to connect to the Exact Financials database. Therefore, ff the client wants to use the Excel Add-In, Progress OpenEdge ODBC drivers must be additionally installed.

Option 1 - install SQL Client Access on clients

This option will install the ODBC drivers locally on the client using a separate installer that contains ODBC driver functionality only.

1. log in to the Progress Software Download Center using your credentials
2. from the product list select 'Progress Deployment Components'
3. from the Progress Deployment Components select 'SQL Client Access'
4. from the 'Previous Releases' tab select '10.1C SQL Client Access'
5. note the serial number and control number for platform 'Win32' and download the file for 'Win32 Intel' - the install file is 72mb
6. run '101c_sqlclientaccess_nt.exe' to install

The above is described in Progress Knowledge Base article P88405.

Option 2 - perform netsetup on clients

This option will install the ODBC drivers from a shared network installation.

1. the folder containing the Progress OpenEdge installation on the server should be shared
2. from the client select the shared folder, select the netsetup folder and run setup.exe

The ODBC drivers will now be available on the client.