Wow! About a decade and a half ago, Microsoft said that OLE DB would be the successor to ODBC. Now, Microsoft announces that "The next release of Microsoft SQL Server, Code Name “Denali,” will be the last release to support OLE DB." For those of us who have been in the industry for so long, this is great news that Microsoft has finally brought some clarity to this. Simba has many customers who use our SimbaEngine SDK for data connectivity solutions for ODBC, JDBC, OLE DB, and ADO.NET and so people often ask us for advice as to which standard to support. We have maintained for years that ODBC and JDBC are the primary relational database connectivity standards and it is great to see this news from Microsoft today to give more clarity to the situation. Just to be clear, I am quoting the entire Microsoft announcement here:
"Today we are announcing that Microsoft is aligning with ODBC for native relational data access – the de-facto industry standard. This move supports our commitment to interoperability and our partners and customers’ journey to the cloud. SQL Azure is already aligned with ODBC today.
The next release of Microsoft SQL Server, Code Name “Denali,” will be the last release to support OLE DB. OLE DB will be supported for 7 years from launch, the life of SQL Server Code Name “Denali” support, to allow you a large window of opportunity for change before deprecation. We encourage you to adopt ODBC in any future version or new application development.
Conversations with our customers and partners have shown that many of you are already on this path. The marketplace is moving away from OLE DB and towards ODBC, with an eye towards supporting PHP and multi-platform solutions. Making this move to ODBC also drives more clarity for our C/C++ programmers who can now focus their efforts on one API. "
You can read the actual blog entry here: Microsoft Aligning with ODBC.