Oracle Database - Oracle ODBC driver

Card Puncher Data Processing

About

The ODBC Oracle driver.

OS

Windows

Access to databases is managed by the Microsoft ODBC Driver Manager. The driver manager provides the linkage between an ODBC application and an ODBC driver for a specific database management system.

The Oracle ODBC driver configuration has changed slightly with each newer version of the ODBC driver, but there are only 2 pieces of information that are absolutely required to create a working Oracle DSN:

  • A DSN Name (whatever you like)
  • A valid SQL*Net connect string (TNS Alias or Oracle 8 service Name)

Linux

Using Oracle ODBC Driver

Support

Driver's SQLAllocHandle on SQL_HANDLE_ENV fail

When you have multiple oracle software installed (such as the Oracle Database and Oracle Warehouse Builder, pay attention that the path of the database bin repository must be the first one in the PATH environment variable otherwise you can have this error:

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV fail

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - ODBC

Microsoft Open Database Connectivity (ODBC) provides a common C programming interface for applications to access data from database management systems (DBMS). You can access: the (meta-)data of Oracle...



Share this page:
Follow us:
Task Runner