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,