How to solve this connection problem with OLEDB?

Question

Well, I'm trying to create an OLE DB connection in Visual Studio (I'm studying ETL), I followed the installation and configuration steps in the video, but mine shows the following error message:

The specified provider is not supported. Please choose different provider in connection manager

Step by step to get to the error message:

1° Within Connection Managers, right-click and choose New OLE DB Conection;

2° Click NEW...;

When I do step 2 it already shows the error message.

I couldn't find anything that could help me, if anyone can help me, I'm grateful in advance.

I'm trying to create a connection between Visual Studio (ETL) and a Database.

Answer 1

Hi @Gabriel Pina,

May I know your version of Visual Studio?

It is highly suggested to use VS2019 for the VS2022 is still under test and do not have GA version for SSIS.

And then you may try to reinstall SSIS extension => uninstall from Control Panel => download from here: SQL Server Integration Services Projects => install.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

The specified provider is not supported.

And which OleDB provider are you trying to use; you haven't mentioned that in any way?

Answer 3

@Gabriel Pina

you can try following solution:

To fix this error, you need to install both of the following:

1- Microsoft OLE DB Driver from this link https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

2-SQL Server Native Client or sqlncli from this link https://www.microsoft.com/en-us/download/details.aspx?id=56041

After installation, check the connection, most likely you will not see any error.