Piezīmes
Lai piekļūtu šai lapai, ir nepieciešama autorizācija. Varat mēģināt pierakstīties vai mainīt direktorijus.
Lai piekļūtu šai lapai, ir nepieciešama autorizācija. Varat mēģināt mainīt direktorijus.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL database in Microsoft Fabric
OLE DB Driver for SQL Server is one technology you can use to access data in a SQL Server database. For a discussion of the different data-access technologies, see Data Access Technologies Road Map.
When you decide whether to use OLE DB Driver for SQL Server as the data access technology for your application, consider several factors.
For new applications, if you use a managed programming language such as Microsoft Visual C# or Visual Basic and need to access the new features in SQL Server, use the .NET Framework Data Provider for SQL Server, which is part of the .NET Framework.
If you develop a COM-based application and need to access the new features introduced in SQL Server, use OLE DB Driver for SQL Server. If you don't need access to the new features of SQL Server, 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 SQL Server. If you have a mature application that doesn't need the new features of SQL Server, you can continue to use WDAC. But if you need to access those new features, such as the xml data type, 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.