My Oracle Support Banner

How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install (Doc ID 1266572.1)

Last updated on JUNE 08, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Microsoft Windows x64 (64-bit)

Goal

Starting with 11R2g Oracle now provides a Database Gateway for ODBC for 64bit Windows operating systems which can be used to connect to any 3rd party database using a suitable 3rd party 64bit ODBC driver.

Please be aware:

- DG4ODBC is first ported to 64bit Windows platforms starting with 11.2 and it is NOT supported to use a 32bit DG4ODBC on a 64bit Windows operating system nor can you use a 32bit ODBC driver with a 64bit DG4ODBC.

The gateway is certified also for older Oracle releases 9.2.0.8, 10.1.0.5, or 10.2.0.3. But please be aware those pre-11g Oracle databases require a patch to work properly with V11 Gateways.

The patch can be found on My Oracle Support by performing a simple search under the 'Patches & Updates' tab at the top of the page. Choose 'Simple Search' and enter 5965763 in the block for the patch number and select the appropriate platform from the Platform or Language list.

This compatibility patch is already included in the 10.2.0.4 patchsets.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows operating systems
 0) ODBC System DSN
 
1) The listener needs a new SID entry like the following:
 2) The tnsnames.ora used by the ORACLE DATABASE needs an entry for the DG4ODBC alias:
 3) init.ora of the gateway:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.