![]() It provides a way to innovate and evolve new data access features without changing the current Windows DAC components, which are now part of the Microsoft Windows platform. OLE DB Driver for SQL Server was designed to provide a simplified method of gaining native data access to SQL Server using OLE DB. ![]() For more information about the use of these features with ADO, see Using ADO with OLE DB Driver for SQL Server. OLE DB Driver for SQL Server allows ADO applications to exploit those new features introduced in SQL Server 2005 (9.x) that are available with OLE DB Driver for SQL Server via connection string keywords or OLE DB properties or Transact-SQL. The OLE DB Driver for SQL Server can be used with OLE DB Core Services supplied with Windows DAC, but this use isn't a requirement the choice to use Core Services or not depends on the requirements of the individual application (for example, if connection pooling is required).ĪctiveX Data Object (ADO) applications may use the OLE DB Driver for SQL Server, but it's recommended to use ADO with the DataTypeCompatibility connection string keyword (or its corresponding DataSource property). ![]() For a list of the differences between OLE DB Driver for SQL Server and Windows DAC, plus information about issues to consider before updating a Windows DAC application to OLE DB Driver for SQL Server, see Updating an Application to OLE DB Driver for SQL Server from MDAC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |