Home | Blogs | rmaclean's blog

OLE DB is dead, long live ODBC

Tue, 08/30/2011 - 09:36 |  Robert MacLean

imageMicrosoft has announced that OLE DB with regards to SQL Server has entered the end of it's life - it has about 7 or 8 years left and "Denali", the next version of SQL Server, will be the last version to support it. The recommendation is to use ODBC going forward.

The reasoning is pretty sound to me:

  1. Better cross platform support - yip Microsoft cares about cross platform.
  2. Better clound support - No surprise that Microsoft cares about the cloud.
  3. I am also assuming that budget is part of this, providing OLE DB & ODBC is two dev teams, two test suites etc… Just doesn’t make sense. Rather consolidate and spend the savings elsewhere.

It is important to note that other OLE DB providers and OLE DB itself are still continuing, we are just talking about SQL Server.

Have a look at the picture to the right only two out of the seven are affected by this announcement, that means there is still a big investment in it and I doubt we we will see OLE DB going away completely anytime soon.

Microsoft has produced a helpful guide to migrating which you can get below.

AttachmentSize
A Quick Guide for OLE DB to ODBC Conversion102.67 KB
Tags: .NET, Development, SQL

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Syntax highlight code surrounded by the <pre class="brush: lang">...</pre> tags, where lang is one of the following language brushes: as3, applescript, bash, csharp, coldfusion, cpp, css, delphi, diff, erlang, groovy, jscript, java, javafx, perl, php, plain, powershell, python, ruby, sass, scala, sql, vb, xml.

More information about formatting options

Twitter
Loading my tweets...
Contact Me | RSS Feed | Back to top


© SADev.co.za, SADev and the content here is copyright 2001-2012 Robert MacLean unless otherwise stated. Content reuse license: Creative Commons Attribution 2.5 South Africa License. Disclose Policy: Disclosure. Disclaimer: The views expressed here reflect the views of the authors alone, and do not necessarily reflect the views of any of their organizations, my customers and clients, employers, sponsors, or contributors. In particular, the views expressed here do not necessarily reflect those of the BBD (my employer) or Microsoft. All information and downloads are available without warranty and any use of such information or downloads is at your own risk. Use common sense. If you don't like what is written then do not read it.