Oracle Database - Oracle ODBC driver

Card Puncher Data Processing


The ODBC Oracle driver.



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)


Using Oracle ODBC Driver


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