Summary

ActiveX Data Objects (ADO) is the Microsoft library, which enables applications to use databases from different vendors (e.g. SQL Server, Oracle, and Informix). PayGlobal uses this library to connect to SQL Server.

Installation

The required ADO library is part of the Microsoft Data Access components.

Check the ADO version

Advanced users can manually check the ADO version. By default, the main ADO dll is located in:

C:\Program Files\Common Files\System\ado\msado15.dll. Right-click the file and select Properties | Version tab.

ADO Providers

ADO connects to a an OLE DB provider written for SQL Server.

The providers that PayGlobal supports are specified in the file DatabaseConnection.ini, located in the PayGlobal application folder. Certain other ini settings are in this file also.

Supported providers match a Regex pattern specified in the ini setting ProviderSearchString. The current search string pattern is (^sqloledb$|^msoledbsql), which covers three of the common providers available:

SQLOLEDB - installed as part of Windows and normally located in C:\Program Files\Common Files\System\Ole DB\sqloledb.dll. This provider is now deprecated by Microsoft but can be used if no other more modern providers are installed.

MSOLEDBSQL - this driver is more modern and is installed as "Microsoft OLE DB Driver for SQL Server" - the maximum version is 18.6.3

MSOLEDBSQL19 - starting from this version MSOLEDBSQL providers can be installed side by side and is installed as "Microsoft OLE DB Driver 19 for SQL Server".

The latest supported provider is specified in the ini setting LatestSupportedVersion and will be set to the highest version PayGlobal supports.

A web link to download the latest supported provider is specified in ini setting LatestProviderLink, and will be displayed when securing or creating a database through PayGlobal.

When securing or creating a database through PayGlobal, a list of supported, installed providers will be shown for the user to select. The latest supported driver is recommended to be used.

Data Encryption

Some providers allow for the use of an encrypted channel between the PayGlobal Desktop application and the PayGlobal Database.

Providers that support encryption are determined by a Regex pattern specified in the ini setting ProvidersSupportingEncryption. The current search string pattern is ^msoledbsql(19|([2-9])[0-9]), which covers the MSOLEDBSQL19 provider.