Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.
-->Drivers are libraries that implement the functions in the ODBC API. Each driver is specific to a particular database management system (DBMS). In most cases, drivers expose the capabilities of the underlying DBMS; they are not required to implement capabilities not supported by the DBMS. Drivers perform specific tasks and can be classified into two categories: file-based and DBMS-based. For more information about drivers and driver architecture, see Drivers.
This section contains the following topics.
-->Important
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.
The Microsoft速 ODBC Driver for Oracle allows you to connect your ODBC-compliant application to an Oracle database. The ODBC Driver for Oracle conforms to the Open Database Connectivity (ODBC) specification described in the ODBC Programmer's Reference. It allows access to PL/SQL packages, XA/DTC integration, and Oracle access from within Internet Information Services (IIS).
Oracle RDBMS is a multiuser relational database management system that runs with various workstation and minicomputer operating systems. IBM-compatible computers running Microsoft Windows can communicate with Oracle database servers over a network. Supported networks include Microsoft LAN Manager, NetWare, VINES, DECnet, and any network that supports TCP/IP.
The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. The driver can access local Oracle databases or it can communicate with the network through SQL*Net. The following diagram details this application and driver architecture.
The ODBC Driver for Oracle complies with API Conformance Level 1 and SQL Conformance Level Core. It also supports some functions in API Conformance Level 2 and most of the grammar in the Core and Extended SQL conformance levels. The driver is ODBC 2.5 compliant and supports 32-bit systems. Oracle 7.3x is supported fully; Oracle8 has limited support. The ODBC Driver for Oracle does not support any of the new Oracle8 data types - Unicode data types, BLOBs, CLOBs, and so on - nor does it support Oracle's new Relational Object Model. For more information about supported data types, see Supported Data Types in this guide.
To access Oracle data, the following components are required:
Oracle Client Download
The ODBC Driver for Oracle
An Oracle RDBMS database
Oracle Client Software
Additionally, for remote connections:
- A network that connects the computers that run the driver and the database. The network must support SQL*Net connections.
Install Odbc Driver For Oracle
Component Documentation
This guide contains detailed information about setting up and configuring the Microsoft ODBC Driver for Oracle and adding programmatic functionality. It also contains technical reference material.
For information regarding specific Oracle product behavior, consult the documentation that accompanies the Oracle product.
Microsoft Odbc For Oracle Setup
For information about setting up or configuring the Microsoft ODBC Driver for Oracle using the ODBC Data Source Administrator, see the ODBC Data Source Administrator documentation.
Free Oracle Odbc Driver Download
This section contains the following topics.