Open Database Connectivity

Open Database Connectivity (ODBC) is a database access API that enables you to connect to a database and then prepare and run SQL statements against Oracle Database XE. In conjunction with an ODBC driver, an application can access any data source including data stored in spreadsheets, such as an Excel spreadsheet.

An Oracle ODBC driver is provided for both Windows and Linux (32 bit). The Oracle ODBC Driver conforms to ODBC 3.51 specifications. It supports all core APIs and a set of Level 1 and Level 2 functions. For Windows, the Driver Manager component is supplied by Microsoft. For Unix platforms, the Oracle Database XE driver has been tested using the latest Driver Manager available from http://www.unixODBC.org.