30.12.2019

Ole Db Provider Download

22

An OLE DB provider is a software component for OLE DB (an API designed by Microsoft) that enables an OLE DB consumer to interact with a data source. OLE DB providers are analogous to ODBC drivers, JDBC drivers, and ADO.NET data providers.

OLE DB providers can be created to access such simple data stores as a text file and spreadsheet, through to such complex databases as Oracle, Microsoft SQL Server, Sybase ASE, and many others. It can also provide access to hierarchical data stores such as email systems.

However, because different data store technologies can have different capabilities, every OLE DB provider cannot implement every possible interface available in the OLE DB standard. The capabilities that are available are implemented through the use of COM objects; an OLE DB provider will map the data store technologies functionality to a particular COM interface. Microsoft describes the availability of an interface as 'provider-specific,' as it may not be applicable depending on the data store technology involved. Note also that providers may augment the capabilities of a data store; these capabilities are known as services in Microsoft parlance.

OLE DB providers[edit]

Jan 29, 2018  This article is about how to download OLE DB Provider for DB2. This is a Microsoft Data Provider which offers tools and technologies using which SQL Server can access DB2 Databases. May 16, 2008  Important download details: Installing the Microsoft OLE DB Provider for Visual FoxPro 9.0 on a computer that has a previous version of the Provider causes. Software Catalogue - Drivers and interfaces. This is PostgreSQL OLE DB Provider project. Implementation, so all you need to do is download a jar file and you. Test the OLE DB Provider Using ADO to Run an SQL Request The Excel ADOTester spreadsheet helps you determine if the ADO MDAC iSeries Access OLE DB Provider is installed and functioning properly. You will have to contact a SEQUEL software support representative to obtain this spreadsheet. Download Microsoft OLE DB Driver for SQL Server.; 2 minutes to read; In this article. APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse. The following version of the Microsoft OLE DB Driver for SQL Server is available for download: Microsoft OLE DB Driver 18.2.2 for SQL Server; See also. OLE DB is a Microsoft data access standard accessed through ActiveX Data Objects (ADO), Visual C, and any client that can use OLE DB. The goal of the Oracle Provider for OLE DB is to have a high performance and rich feature mechanism for data access to Oracle databases The Oracle Provider for OLE.

The Microsoft OLE DB Provider for ODBC (MSDASQL) is a technology that allows applications that are built on OLEDB and ADO (which uses OLEDB internally) to access data sources through an ODBC driver. MSDASQL is an OLEDB provider that connects to ODBC, instead of a database.

For example, Microsoft ships a few OLE DB providers as part of its MDAC and JET kits; Simba Technologies ships SimbaProvider, an SDK used to build custom OLE DB for OLAP providers for multi-dimensional and star schema database connectivity; OpenLink Software ships components supporting OLE DB access to a number of data sources, including several SQL DBMS, as well as bridges to ODBC- and JDBC-accessible data sources.

External links[edit]

  • 'OLE DB Providers Overview'. Microsoft. MSDN: Data Developer Center. Retrieved 23 March 2011.


Retrieved from 'https://en.wikipedia.org/w/index.php?title=OLE_DB_provider&oldid=892314648'
-->

APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

Postgresql

The OLE DB Driver for SQL Server is a stand-alone data access application programming interface (API), used for OLE DB, that was introduced in SQL Server 2005 (9.x). OLE DB Driver for SQL Server delivers the SQL OLE DB driver in one dynamic-link library (DLL). It also provides new functionality above and beyond that supplied by the Windows Data Access Components (Windows DAC, formerly Microsoft Data Access Components, or MDAC). The OLE DB Driver for SQL Server can be used to create new applications or enhance existing applications that need to take advantage of features introduced in SQL Server 2005 (9.x), such as multiple active result sets (MARS), user-defined data types (UDT), query notifications, snapshot isolation, and XML data type support.

Note

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.

Important

The previous Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and SQL Server Native Client OLE DB provider (SQLNCLI) remains deprecated and it is not recommended to use either for new development work.

The OLE DB Driver for SQL Server can be used in conjunction with OLE DB Core Services supplied with Windows DAC, but this is not 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).

ActiveX Data Object (ADO) applications may use the OLE DB Driver for SQL Server, but it is recommended to use ADO in conjunction with the DataTypeCompatibility connection string keyword (or its corresponding DataSource property). When using the OLE DB Driver for SQL Server, ADO applications may exploit those new features introduced in SQL Server 2005 (9.x) that are available via the OLE DB Driver for SQL Server via connection string keywords or OLE DB properties or Transact-SQL. 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 was designed to provide a simplified method of gaining native data access to SQL Server using OLE DB. 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.

While OLE DB Driver for SQL Server uses components in Windows DAC, it is not explicitly dependant on a particular version of Windows DAC. You can use OLE DB Driver for SQL Server with the version of Windows DAC that is installed with any operating system supported by OLE DB Driver for SQL Server.

Different generations of OLE DB Drivers

There are three distinct generations of Microsoft OLE DB providers for SQL Server.

1. Microsoft OLE DB Provider for SQL Server (SQLOLEDB)

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) still ships as part of Windows Data Access Components. It is not maintained anymore and it is not recommended to use this driver for new development.

2. SQL Server Native Client (SNAC)

Starting in SQL Server 2005 (9.x), the SQL Server Native Client (SNAC) includes an OLE DB provider interface (SQLNCLI) and is the OLE DB provider that shipped with SQL Server 2005 (9.x) through SQL Server 2012 (11.x).

It was announced as deprecated in 2011 and it is not recommended to use this driver for new development. For more information about the SNAC lifecycle and available downloads, refer to SNAC lifecycle explained.

3. Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)

Historian ole db provider download

OLE DB was undeprecated and released in 2018.

The new OLE DB provider is called the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). The new provider will be updated with the most recent server features going forward.

Note

Luxor amun rising hd crack. To use the new Microsoft OLE DB Driver for SQL Server in existing applications, you should plan to convert your connection strings from SQLOLEDB or SQLNCLI, to MSOLEDBSQL.

Microsoft Ole Db Provider Download

In this section

When to use OLE DB Driver for SQL Server
Discusses how OLE DB Driver for SQL Server fits in with Microsoft data access technologies, how it compares to Windows DAC and ADO.NET, and provides pointers for deciding which data access technology to use.

Sql Server Oledb Provider Download

OLE DB Driver for SQL Server features
Describes the features supported by OLE DB Driver for SQL Server.

Building applications with OLE DB Driver for SQL Server
Provides an overview of OLE DB Driver for SQL Server development, including how it differs from Windows DAC, the components that it uses, and how ADO can be used with it.

This section also discusses OLE DB Driver for SQL Server installation and deployment, including how to redistribute the OLE DB Driver for SQL Server library.

Historian Ole Db Provider Download

System requirements for OLE DB Driver for SQL Server
Discusses the system resources needed to use OLE DB Driver for SQL Server.

Ole Db Provider 12.0 Download

OLE DB Driver for SQL Server programming
Provides information about using the OLE DB Driver for SQL Server.

Finding more OLE DB Driver for SQL Server information
Provides additional resources about OLE DB Driver for SQL Server, including links to external resources and getting further assistance.

See also

Updating an application from SQL Server 2005 Native Client
OLE DB how-to topics