How To Configure DG4ODBC - Firebird

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)
0) ODBC System DSN
Install firebird odbc driver
https://firebirdsql.org/en/odbc-driver/
Please open the ODBC Administrator (make sure to use the 64bit ODBC
Administrator and configure a 64bit ODBC driver when using 64bit DG4ODBC) and
configure a SYSTEM DSN choosing your ODBC driver and following its onscreen
dialog.
1) listener (in the ORACLE_HOME where the gateway software is installed)
How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows To
Operating Systems to Connect to Non-Oracle Databases Post Install (Doc ID 1266572.1) Bottom
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
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Microsoft Windows x64 (64-bit)
*** Checked for relevance on 03-Apr-2015 ***
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
How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows operating
systems
The Oracle Database Gateway for ODBC comes on a separate CD. It can be installed into an
existing 11gR2 database Oracle_Home (please pay attention: if the Oracle_Home contains an
already patched release of the database, you MUST apply this patchset again. The reason is
the gateway installation might overwrite already patched libraries with the base version as
delivered on the CD. To get a proper environment again, the already applied patchset needs
to be reapplied).
After the installation the following items must be configured:
0) ODBC SYSTEM DSN

1) listener (in the ORACLE_HOME where the gateway software is installed)
2) tnsnames (in the ORACLE_HOME where the Oracle database software is installed)
3) init<SID>.ora of the hs subsystem (in the ORACLE_HOME where the gateway software
is installed)
4) Oracle database
0) ODBC System DSN
Please open the ODBC Administrator (make sure to use the 64bit ODBC Administrator and
configure a 64bit ODBC driver when using 64bit DG4ODBC) and configure a SYSTEM
DSN choosing your ODBC driver and following its onscreen dialog.
1) The listener needs a new SID entry like the following:

C:\app\tg\HSSAdmin\product\12.1.0\tghome_1\hs\admin
listener.ora
The listener must be stopped and started after changing the listener.ora file!
2) The tnsnames.ora used by the ORACLE DATABASE needs an entry for the DG4ODBC alias:
tnsnames.oRA
3) init.ora of the gateway:
initdg4odbc.ora
Short explanation of the parameters:

HS_FDS_CONNECT_INFO points to the SYSTEM DSN created with the ODBC Administrator
in step 0.
4) Configuring the Oracle database

The only thing that must be done here is to create a database link: connect with the
username/password that has sufficient rights to create a database link (i.e. system).
The syntax is:
CREATE DATABASE LINK fbdb CONNECT TO "sa" IDENTIFIED BY "sa" USING 'dg4odbc';
select rdb$relation_name from rdb$relations dg4odbc

How To Configure DG4ODBC - Firebird

Uploaded by

Copyright:

Available Formats

How To Configure DG4ODBC - Firebird

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

How To Configure DG4ODBC - Firebird

Uploaded by

Copyright:

Available Formats

How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows

Operating Systems to Connect to Non-Oracle Databases Post Install (Doc ID

0) ODBC System DSN

Install firebird odbc driver

0) ODBC System DSN

1) The listener needs a new SID entry like the following:

3) init.ora of the gateway:

This compatibility patch is already included in the 10.2.0.4 patchsets.

After the installation the following items must be configured:

0) ODBC SYSTEM DSN

0) ODBC System DSN

1) The listener needs a new SID entry like the following:

3) init.ora of the gateway:

Short explanation of the parameters:

4) Configuring the Oracle database

select rdb$relation_name from rdb$relations dg4odbc

You might also like