Share via

How do I use SMO with OleDBConnection

Nayak, Lakshminarayan 20 Reputation points
2024-08-23T07:35:42.03+00:00

I belive SMO uses Sql Native Client internally. Per this article https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver16, Sql Native Client is being deprecated and Microsoft is encouraging users to switch to MSOLEDBSQL. So how does one configure SMO to use OleDB ? If this cannot be done, is SMO too being deprecated ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,683 questions
0 comments
Accepted answer
  1. Erland Sommarskog 110.4K Reputation points MVP
    2024-08-23T21:14:34.8866667+00:00

    No, SMO is implemented in .NET and uses SqlClient to connect to SQL Server. It's not using OLE DB.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.