VS 19, SSIS project, getting and error "The specified provider is not supported. Please choose different provider in connection manager" when choosing OLEDB as the connection type

Seeley, Steve 10 Reputation points
2023-04-26T00:34:01.27+00:00

Using Visual Studio 19 on new laptop. Have installed the SSIS template. I also have SSMS 19 installed. I create a new project and try and create a new Connection Manager. I select OLEDB and click Add... On the next screen to configure the OLE DB I select New... and I get the following error: User's image

If I look in Programs and Features I see that I have Microsoft OLE DB Driver for SQL Server v. 18.6.5.0 installed. What am I missing?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,765 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
0 comments No comments
{count} vote

4 answers

Sort by: Most helpful
  1. TJH 45 Reputation points
    2023-06-08T13:03:47.4866667+00:00

    Either change the Provider from "Native OLE DB" to "Microsoft OLE DB Provider for SQL Server" or change the connection type to ADO.NET.

    The later has some syntax differences though.

    https://www.sqlshack.com/ssis-connection-managers-ole-db-vs-odbc-vs-ado-net/

    1

    2

    9 people found this answer helpful.

  2. Tianyu Sun-MSFT 28,671 Reputation points Microsoft Vendor
    2023-04-26T07:41:03.1766667+00:00

    Hello @Seeley, Steve,

    Welcome to Microsoft Q&A forum.

    I tested on my side by only installing VS 2019 and SSIS extension > Creating a new Integration Services Project > right-clicking Connection Managers > clicking New Connection Manager option > selecting to add and create a new connection(OLEDB), it worked well, and I failed to reproduce your issue.

    Except installing VS 2019, SSIS and SSMS, did you change some default settings or customize the default configurations in SSMS and newly created IS project?

    I suggest first try to reinstall SSIS extension => uninstall from Control Panel => download from here: SQL Server Integration Services Projects => install.

    Confirm that in VS Installer > Modify > Individual components > SQL Server Data Tools component is checked.

    Best Regards,

    Tianyu


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. Maria Palacios Ibarra 0 Reputation points
    2023-06-22T04:55:12.85+00:00

    Does someone find out how to solve this problem, I am also getting the same error with no clue how to solve it


  4. pantea khajavi 0 Reputation points
    2024-06-05T17:05:35.85+00:00

    @Seeley, Steve

    @Maria Palacios Ibarra

    let's try following solution:

    "The specified provider is not supported . Please select another provider in connection manager”

    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.

    0 comments No comments