How to change default ole db provider on VS 2022 ssis connection manager?

Adi Shahar 0 Reputation points
2024-01-25T13:30:58.8066667+00:00

Hi, I install on my new pc Visual Studio 2022 Version 17.8.3 with SSIS Extension 1.3.2. When i try to add new connection to OLE DB there an error appeared: "The Specified provider is not supported. Please choose different provider in connection manager." After checking the problem, it seems that the default connection manager is "SQL Native Client 11" that deprecated. Is there option to change the default provider to "Microsoft OLE DB Driver 19 SQL Server"?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,589 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,376 Reputation points
    2024-01-26T03:29:16.91+00:00

    Hi @עדי מרדכי שחר,

    You could not change default ole db provider.

    SQL Server Native Client (SQLNCLI11.1) is deprecated and not installed by VS2022. We recommend upgrading to the new Microsoft OLE DB driver for SQL Server. If you want to continue using SQL Server Native Client, you can download and install it from here.

    Regards,

    Zoe Hui


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

    1 person found this answer helpful.

  2. Yitzhak Khabinsky 25,956 Reputation points
    2024-01-25T20:51:28.0433333+00:00

    Shalom עדי מרדכי שחר, VS2022 and its "SQL Server Integration Services Projects" extension don't have a default OLE DB provider. What you need to is to install Microsoft OLEDB Driver from here: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16 and start using it.


    • If you are using MS SQL Server below 2022, you can use Microsoft OLEDB Driver v.18.6.7
    • If you are using MS SQL Server 2022, it is better to use Microsoft OLEDB Driver v.19.3.2

Your answer

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