| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
When to Use OLE DB Driver |
Learn when to use OLE DB Driver for SQL Server and the high level data access concepts that differentiate the different it from other drivers. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
OLE DB Driver for SQL Server is one technology that you can use to access data in a [!INCLUDEssNoVersion] database. For a discussion of the different data-access technologies, see Data Access Technologies Road Map
When deciding whether to use OLE DB Driver for SQL Server as the data access technology of your application, you should consider several factors.
For new applications, if you're using a managed programming language such as Microsoft Visual C# or Visual Basic, and you need to access the new features in [!INCLUDEssNoVersion], you should use the .NET Framework Data Provider for [!INCLUDEssNoVersion], which is part of the .NET Framework.
If you are developing a COM-based application and need to access the new features introduced in [!INCLUDEssNoVersion], you should use OLE DB Driver for SQL Server. If you don't need access to the new features of [!INCLUDEssNoVersion], you can continue to use Windows Data Access Components (WDAC).
For existing OLE DB applications, the primary issue is whether you need to access the new features of [!INCLUDEssNoVersion]. If you have a mature application that does not need the new features of [!INCLUDEssNoVersion], you can continue to use WDAC. But if you do need to access those new features, such as the xml data type, you should use OLE DB Driver for SQL Server.
Both OLE DB Driver for SQL Server and MDAC support read committed transaction isolation using row versioning, but only OLE DB Driver for SQL Server supports snapshot transaction isolation. (In programming terms, read committed transaction isolation with row versioning is the same as Read-Committed transaction.)
For information about the differences between OLE DB Driver for SQL Server and MDAC, see Updating an Application to OLE DB Driver for SQL Server from MDAC.