MS-SQL DB LINK(dg4msql) does not work in ORACLE12C RAC
- ORACLE VERSION : ORACLE 12C
- MSSQL CONNECT PROGRAM : dg4msql
- OS: AIX6.1
- RUN SQL : SELECT
- DB LINK NAME : DG4MSQL5T
- RUN SQL : SQL> SELECT * FROM "IDC"@DG4MSQL5T ;
- ERROR :
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[DataDirect][ODBC lib] Data source name not found and no default driver specified (IM002)
ORA-02063: preceding 2 lines from TE DG4MSQL5T
*Cause:
The cause is explained in the forwarded message
*Action: See the non-Oracle system's documentation of the forwarded