Go to Top

OLE DB Undeprecated! Long live ADO!

The Microsoft SQLNCli team has undeprecated OLE DB and the news could very well be earth shattering for the Microsoft Access community.

Previously deprecated and last supported with SQL Client 11, OLE DB was on it’s last breaths, and what was worse, we could not come up with a equivalent solution using DAO and pass through queries for all the features we had with OLE DB. Thankfully the team in charge of the connectivity drivers realized the huge impact and reversed the decision. 

SQL Server Hosting

Expect a new updated driver the first quarter of 2018 with great integration with SQL Azure.

What does it mean?

  • We can finally use ADODB with Azure AD integration in Access, something we can’t do with client 11.
  • We no longer have to worry about re-writing a ton of applications using DAO only.
  • We can continue to invoke ADODB commands in our code and interact directly with SQL Server without using a pass through query.
  • We can enjoy all the current and future capabilities SQL Server has to offer.

You can learn more about the decision here: https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

3 Responses to "OLE DB Undeprecated! Long live ADO!"

  • Anita Young
    April 13, 2018 - 1:42 am Reply

    Any dates identified for the release of the new OLE that supports TLS 1.2?

  • MarkNZ
    April 9, 2018 - 9:41 am Reply

    Any chance they will also undeprecate the ADP format too 😉

  • Patrick Wood
    October 21, 2017 - 7:17 am Reply

    Thanks Juan! This is super great news!

Leave a Reply

Your email address will not be published. Required fields are marked *


Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.