Provider cannot be found Error Message

This issue only related to working with SQL Server

SQL Server

Our software uses both OLE DB and ODBC SQL Server drivers. ODBC is used for importing and exporting data, while OLE DB is used for repository connections, SQL scripts, loops, and data editing.

Client and Driver Selection

The software identifies the highest available ODBC driver and selects the corresponding OLE DB provider for compatibility.

The selection logic follows this hierarchy:

Potential Issue

If a matching OLE DB provider for the selected ODBC driver is not available, some operations may fail or produce errors.

Solution 1

To resolve this, install the latest version of Microsoft SQL Server Management Studio (SSMS).
This will also install the most recent drivers, ensuring compatibility between ODBC and OLE DB components. For additional assistance, refer to Microsoft’s documentation on downloading and installing SSMS.

Solution 2

Install latest drivers manually

Here are the download links

• SQL Server ODBC Drivers
• List of OleDB drivers download links

Solution 3

Select OleDB Provider manually

MS Access

The user may receive the message above after installing 64 version of our ETL Software. This is because by default 64 bit OLE driver for MS Access is not installed on Windows. Although it is possible to install 64 bit OLE driver for MS Access by using our software we strongly recommend against it. The best course of actions is to use a proper database as repository such as MS SQL Server or Oracle.

Installing MS Access Runtime

During setup, our software will install Access runtime if selected