Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

OpenLink ODBC drivers for Oracle

Versions

OpenLink ODBC driver for Oracle supports Oracle versions 7.x, 8.x, 9i, 10g, XE and 11g

Driver Architecture

OpenLink's Oracle ODBC drivers are available in a choice of three formats to suit your network infrastructure.

  • Single-Tier (Express) More Information / Download

    A single-tier driver: easy installation on Mac OS X Universal and Microsoft Windows platforms.

  • Single-Tier (Lite) More Information / Download

    A single-tier driver: simple and quick to deploy; installs on the client computer only; uses a database-specific communications layer

  • Multi-Tier (Enterprise Edition) More Information / Download

    A multi-tier driver with configurable performance, scalability and security for Enterprise users; typically components are installed on both the client and database-server hosts.

Features

Feature / Architecture Single-Tier
(Express)
Single-Tier
(Lite)
Multi-Tier
(Enterprise Edition)
More Information and Download More Information and Download More Information and Download
Microsoft Windows and Mac OS X Availability Y Y Y
Linux, Solaris and other Unix OS Availability N Y Y
Single component client-only installation Y Y N
Multiple components installed on clients and server computers N N Y
Requires database-specific comms layer on client N Y N
SQL-92 Conformance Y Y Y
ODBC Core, Level 1 and Level 2 Compliance Y Y Y
Unicode Support Y Y Y
Support for Built-in Client-side Tracing Y Y Y
Configurable performance N Y Y
Configurable for Scalability N N Y
Configurable Security N N Y
Ability to restrict connections based on application, IP address, username, requested database N N Y
Ability to override connection parameters on the server N N Y
Operating-system user authentication N N Y
Connection Pooling N Y Y
Instant Client Support N Y Y
MS DTC N N Y
Real Application Cluster (RAC) Support N Y Y
Reference Cursors in Stored Procedures N Y Y
Static, Keyset, Forward-Only Cursors N Y Y
XA-Based Two-Phase Commit N N Y

Applications

Our ODBC driver for Oracle allows you to connect desktop applications such as Microsoft Access and Excel/Query, OpenOffice, reporting tools such as Crystal Reports/Business Objects, and more, to your backend database.

Additionally, our ODBC driver facilitates database connectivity for developers programming in scripting languages such as Perl (using DBI and DBD::ODBC), Python (using mxODBC or PyODBC), Ruby, SoftIntegration's Ch language, Microsoft Visual Studio 2005, C and C#.

Download

For a guided download, use our Solution Wizard.

If you know what components you need, you can proceed via the Download Wizard.