Friday, 2 September 2011
Microsoft drops support for OLE DB after SQL Server Denali is released
ODBC is the de-facto industry standard for native relational data access, which is supported on all platforms including SQL Azure. Cloud is universal and in order to support all client applications connecting from any platform to the cloud, Microsoft has been fully aligned with ODBC on SQL Azure, as ODBC is the only set of APIs that are available on all platforms including non-Windows platforms.
The next release of Microsoft SQL Server, codename “Denali”, will be the last release to support OLE DB. OLE DB will be supported for 7 years from launch, the life of Denali support, to allow you a large window of opportunity for changing your applications before the deprecation. This deprecation applies to the Microsoft SQL Server OLE DB provider only. Other OLE DB providers as well as the OLE DB standard will continue to be supported until explicitly announced.
We encourage you to adopt ODBC in the development of your new and future versions of your application.
I remember that they wanted OLE DB and ADO.Net be their “universal data access”…. Obviously, they are changing direction now. Well, we have 7 years to adapt