Share via

How to solve this connection problem with OLEDB?

Gabriel Pina 5 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

SQL Server Integration Services
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. pantea khajavi 20 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://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.

    Was this answer helpful?

    0 comments
  2. Olaf Helper 47,616 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?

    Was this answer helpful?

    0 comments
  3. ZoeHui-MSFT 41,551 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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.