Support is added for time stamp with time zone and time stamp with local time zone. In previous releases, the object length limit was 30 bytes. Oracle ODBC Driver now supports object lengths of 128 bytes. New Features for Oracle ODBC Driver Release 12.2.0.1.0įeatures of the Oracle ODBC Driver Release 12.2.0.1.0 software for the Microsoft Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows 7, Windows 8, Windows 8.1, Windows 10, Linux X86-64 (32/64 bit), Sun Solaris SPARC64 (32,64 bit), IBM AIX 5L (32,64 bit), Sun Solaris X64 (32,64 bit), HPUX IA64 (32,64 bit), ZLinux (32,64 bit) operating systems are described as follows: This figure shows an ODBC application accessing three separate databases. The ODBC Driver accesses the database over a network communications link using the database API.

Still using the ODBC API, the Driver Manager makes a call to the ODBC Driver. The Driver Manager can be either the Microsoft Driver Manager or the unixODBC Driver Manager. The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API). The following figure shows the components of the ODBC model. 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. 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.

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.

The application's source code does not have to be recompiled for each data source. Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources.

Odbc connection oracle 10g