ODBC connection from oracle db in UNIX to MS SQL Server db

[dbasan]

Dear all,

I need to setup db link for odbc connection from Oracle in HP-Unix to MS SQL Server. Can anyone provide me steps on how to set up? I understand that this may require ODBC driver, but I am not sure what kind of driver I will need?

Thanks,
Unna

You have two options to do this:
1. ODBC driver installed in HP-unix and using a dblink - requires a private vendor license for the driver.
2. Transparent gateway which is installed in windows(SQL server) and using a dblink - which requires license from Oracle.

Browse Metalinks for the setup documents.