CODEWITHSUNDEEP
sqlsql-serversql-server-2012mfcoledb
Nihal Kumar
Nihal Kumar

Reputation: 325

SQLOLEDB Deprecated

I have been browsing for an answer from last one month. Now I could not resist myself to post it here and discuss my observations with experts. Please find my observations/doubt:

I am using SQLOLEDB and SQL Server 2008 R2 As per MSDN, The commercial release of Microsoft SQL Server, codename "Denali"(SQL Server 2012) will be the last release to support OLEDB. Reference : MSDN BLOG

On the other hand it is mentioned that the OLEDB data consumers are supported till SQL Server 2014 Reference : MSDN Reference

Now I need to upgrade my tool to work with SQL Server 2012 and all of the later version. However I checked my application with SQL Server 2012 and found working fine without changing anything.

So not sure how it is working and which announcement shall i follow and shall i change my code and switch to other DB access methodology(SQL Native, ODBC) Any suggestion will be really helpful.

Many Many Thanks in advance.

Few more link on Stack overflow itself : Stack overflow link

Upvotes: 4

Views: 2478

Answers (1)

Igor Micev
Igor Micev

Reputation: 1662

SQL Server 2012 is the last version to support SQL OLE DB connections. So, if you're on SQL Server 2012, then you're still fine.

For future versions, Microsoft gives this article to convert your application from OLE DB to ODBC - https://msdn.microsoft.com/en-us/library/hh967418.aspx

Upvotes: 2

Related Questions