The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,706 other followers

Lots of projects did not get it yet, but for connecting to SQL Server: RIP OLE DB

Posted by jpluimers on 2013/07/17

I still see a truckload of projects that connect to SQL Server do this using OLE DB or the Native SQL Client.

All OLE DB access to SQL Server has been deprecated, not only from regular access, but also from SSIS.

These are the only ways you should connect to SQL Server:

  • SqlClient (managed code)
  • JDBC (Java)
  • ODBC (for native code)

For instance, these have been deprecated (for each one, I linked to the oldest SQL Server version where they were made available for):

  1. SQLOLEDB
  2. SQLNCLI
  3. SQLNCLI10
  4. SQLNCLI11
  5. SQLXMLOLEDB.3.0
  6. SQLXMLOLEDB.4.0

–jeroen

via: RIP OLE DB.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: