The Wiert Corner – irregular stream of stuff

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

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 1,860 other subscribers
«
»

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.

This entry was posted on 2013/07/17 at 06:00 and is filed under Database Development, Development, SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a comment

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

«
»