Announcing the new release of OLE DB Driver for SQL Server

Previously, Microsoft announced deprecation of the Microsoft OLE DB Provider for SQL Server, part of the SQL Server Native Client (SNAC). At the time, this decision was made to try to provide more simplicity for the developer story around Windows native software development as we moved into the cloud era with Azure SQL Database, and…


Microsoft is Aligning with ODBC for Native Relational Data Access

EDIT (10/6/2017): OLE DB is being undeprecated. Read more about it here. ODBC is the de-facto industry standard for native relational data access, which is supported on all platforms including SQL Azure. Cloud is universal and in order to support all client applications connecting from any platform to the cloud, Microsoft has been fully aligned…

40

SQL Server Native Client: Connection strings and OLE DB

(Anton Klimov, a developer on the SQL Server Native Client team, wrote the following article.)   Connection strings for an OLE DB provider is a concept that causes a lot of confusion. One problem is that OLE DB itself does not define connection string as a provider concept.   The documentation at Connection String Syntax (http://msdn.microsoft.com/en-us/library/ms722656(VS.85).aspx)…


Welcome to the Microsoft SQL Server Native Client Team Blog

Welcome! In this blog you will find posts about Microsoft SQL Server Native Client, or SQL Native Client for short. This is the component that provides ODBC and OLE DB support for Microsoft SQL Server from SQL Server 2005 onwards. I’ll get the ball rolling with a FAQ about native data access for SQL Server…

2

Native Data Access for SQL Server 2005 FAQ

Native Data Access for SQL Server 2005 FAQIn SQL Server 2005 Microsoft decided to change the way it supports ODBC and OLE DB with the introduction of Microsoft SQL Server Native Client (SQL Native Client), a new component of SQL Server 2005. This FAQ answers some basic questions about SQL Native Client and about ODBC…

10

Introducing SQL Native Client

Introducing SQL Native Client [This was originally posted on the DataWorks blog which is now suspended] By now you may have heard of a new data access technology called “SQL Native Client” that will ship with SQL Server 2005. But before we go much further in discussing it, let’s be clear about what we mean…

4

Getting started with SQL Native Client

Getting started with SQL Native Client [Chris Lee] [This was originally posted on the DataWorks blog which is now suspended] As Acey Bunch explained in April, SQL Native Client meets the needs of developers wanting to take advantage of new features in SQL Server 2005 from ADO, ODBC and OLE DB applications. For those of…

2

Using MARS with SQL Native Client

Using MARS with SQL Native Client [Chris Lee] [This was originally posted on the DataWorks blog which is now suspended] As stated in my previous post, the majority of new features available through SQL Native Client are accessed by connection or statement properties. MARS is about the simplest new feature to use in SQL Server…

2