Oracle Database - ODBC

Card Puncher Data Processing

About

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 Database through an Oracle driver
  • the (meta-)data of other data source inside the Oracle database through the help of an ODBC client: gateway agent.





Discover More
Card Puncher Data Processing
Oracle Database - Client Application

Installing Oracle Database Client on any computer allows easy access from that system to the Oracle Database. The installation also includes the following development tools: Oracle JDBC drivers Oracle...
Card Puncher Data Processing
Oracle Database - Gateway (Heterogeneous services)

Gateway (Or Heterogeneous Services before 11g) make a non-Oracle system appear as a remote Oracle Database server through program that are called agent. The Oracle ODBC agent acts as an ODBC client and...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Oracle Database Installationl Location 11gr2 Oel Linux X86 64
Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)

Installation of Oracle Database 11g Release 2 (11.2) x86_64 on Oracle Enterprise Linux 5 Update 5 on the file system (ie without ASM) or GRID. Linux OEL installation login as root ...



Share this page:
Follow us:
Task Runner