Database Administration (MOSC)

MOSC Banner

MS-SQL DB LINK(dg4msql) does not work in ORACLE12C RAC

  1. ORACLE VERSION : ORACLE 12C
  2. MSSQL CONNECT PROGRAM : dg4msql
  3. OS: AIX6.1
  4. RUN SQL : SELECT
  5. DB LINK NAME : DG4MSQL5T
  6. RUN SQL : SQL> SELECT * FROM "IDC"@DG4MSQL5T ;
  7. 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center