How to solve this connection problem with OLEDB?

Gabriel Pina 0 Reputation points
2023-05-09T17:27:07.5833333+00:00

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.Print3

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,814 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,756 Reputation points
    2023-05-10T01:28:51.64+00:00

    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.

  2. Olaf Helper 42,746 Reputation points
    2023-05-10T05:15:03.52+00:00

    The specified provider is not supported.

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

    0 comments
  3. pantea khajavi 0 Reputation points
    2024-06-05T17:10:20.3633333+00:00

    @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://video2.skills-academy.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.

    0 comments