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

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. - Change the config. - Restart the listener. - Reconnect to the Oracle database. - Test the database link. 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...