kcnomad.blogg.se - Oracle odbc driver configuration description

#Oracle odbc driver configuration description driver
#Oracle odbc driver configuration description code
#Oracle odbc driver configuration description windows

SQL syntax based on the SQL-99 specification.Ī standard way to connect to and log in to a data source.Ī standard representation for data types.įigure 24-1 shows the components of the ODBC model. The ODBC interface defines the following:Ī library of ODBC function calls that allows an application to connect to a data source, execute structured query language (SQL) statements, and retrieve results.

#Oracle odbc driver configuration description driver

Therefore, the application can access any data source for which a database driver exists. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. A database driver links the application to a specific data source.

#Oracle odbc driver configuration description code

The application's source code does not have to be recompiled for each data source. This section contains the following topics.Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources. It also contains technical reference material.įor information regarding specific Oracle product behavior, consult the documentation that accompanies the Oracle product.įor 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. This guide contains detailed information about setting up and configuring the Microsoft ODBC Driver for Oracle and adding programmatic functionality. The network must support SQL*Net connections.

A network that connects the computers that run the driver and the database.

To access Oracle data, the following components are required: For more information about supported data types, see Supported Data Types in this guide. 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. Oracle 7.3x is supported fully Oracle8 has limited support. The driver is ODBC 2.5 compliant and supports 32-bit systems. It also supports some functions in API Conformance Level 2 and most of the grammar in the Core and Extended SQL conformance levels. The ODBC Driver for Oracle complies with API Conformance Level 1 and SQL Conformance Level Core.

The following diagram details this application and driver architecture. The driver can access local Oracle databases or it can communicate with the network through SQL*Net. The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. Supported networks include Microsoft LAN Manager, NetWare, VINES, DECnet, and any network that supports TCP/IP.

#Oracle odbc driver configuration description windows

IBM-compatible computers running Microsoft Windows can communicate with Oracle database servers over a network. Oracle RDBMS is a multiuser relational database management system that runs with various workstation and minicomputer operating systems. It allows access to PL/SQL packages, XA/DTC integration, and Oracle access from within Internet Information Services (IIS). The ODBC Driver for Oracle conforms to the Open Database Connectivity (ODBC) specification described in the ODBC Programmer's Reference. The Microsoft® ODBC Driver for Oracle allows you to connect your ODBC-compliant application to an Oracle database.

Instead, use the ODBC driver provided by Oracle. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

This feature will be removed in a future version of Windows.