4

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

Community
  • 1
  • 1
Nihal Kumar
  • 305
  • 3
  • 16

1 Answers1

2

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

Igor Micev
  • 1,514
  • 1
  • 17
  • 23
  • 2
    I am using SQL Server 2014 and it is working here as well. Don't know what's is being messed up :P – Nihal Kumar Jul 12 '16 at 05:31
  • not anymore https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/ – CWilson Sep 11 '18 at 18:03