Breaking Changes - SQLOLEDB to MSOLEDBSQL/MSOLEDBSQL19 (SQL OLE DB Provider to SQL OLE DB Driver)

Clive Crocker 1 Reputation point
2022-11-08T10:56:14.397+00:00

Hello.

Very much behind the times, one of our clients needs to migrate their applications from using SQLOLEDB to MSOLEDBSQL or better MSOLEDBSQL19 (i.e. the original OLE DB Provider for SQL Server to the latest OLE DB Driver 19 for SQL Server).

In descriptive terms, from Microsoft OLE DB Provider for SQL Server to Microsoft OLE DB Driver 19for SQL Server

I am sure I read, long ago, an article describing a bunch of fringe cases where there were behavioural differences in terms of data handling between the 'Provider' and the 'Driver'.

However despite extensive online searching I can no longer find anything detailing that... the only things are differences between V18 and V19 Drivers.

Just to be clear (as I recall) SQLOLEDB was released years ago as part of MDAC (Microsoft Data Access Components) and was (theoretically) replaced by the SQL Native Client as the supported way to connect. Yes the client should have already made this change... but we are where we are.

Do you have any tech articles in the archives which can be made available to assist so we can attempt to pre-empt any unexpected changes in behaviour which may not obviously come to the surface?

Thank you,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,863 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Clive Crocker 1 Reputation point
    2022-11-08T11:57:17.32+00:00
    0 comments
  2. Erland Sommarskog 78,581 Reputation points MVP
    2022-11-08T23:06:47.967+00:00

    The move from SQLOLEDB to MSOLEDBSQL should mostly be painless, I think.

    Moving to MSOLEDBSQL19 on the other hand requires a little more work, since this drive defaults to requiring encrypted connections. Then again, if you are already using Encrypt=True, it may not be that much difference.

    0 comments
  3. Seeya Xi-MSFT 16,261 Reputation points
    2022-11-09T06:16:32.203+00:00

    Hi @Clive Crocker ,

    You posted the correct link! To use the new Microsoft OLE DB Driver for SQL Server in existing applications, you should plan to convert your connection strings from SQLOLEDB or SQLNCLI, to MSOLEDBSQL19 or MSOLEDBSQL.
    Also, I'll post another link: Microsoft OLE DB Driver for SQL Server

    Best regards,
    Seeya

    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.

    0 comments