8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Misc » Here

Heterogeneous Services (Generic Connectivity) : Oracle to Non-Oracle Database Links Using ODBC

Oracle supports heterogeneous services to allow data in non-Oracle database to be queried using SQL. This support has been in the form of transparent gateways, which are vendor specific, or generic connectivity which uses ODBC or OLEDB to make the connections. The functionality supported by generic connectivity is typically more limited than that possible when using vendor specific gateways, but it is quick and simple to configure. The steps listed below can be used to connect Oracle to any ODBC compliant database (MS Access, SQL Server, MySQL etc.).

Related articles.

Setup

In the following example, "SQLSERVER1" is the ODBC Data Source Name (DSN) of the non-Oracle database.

Troubleshooting Tip

Depending on your environment, you may have to play around with the settings in the "$ORACLE_HOME/hs/admin/initSQLSERVER1.ora" file. To make sure you are testing these changes properly, remember to use the following process.

Some config changes will not be visible until you reconnect to the database, so play it safe and always use this procedure.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.