Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Smile Unanswered: How to create Database link in MsSqlServer to Oracle8i

    Hi All,
    Can somebody please help me, how to create database link to Oracle from MsSqlServer200.

    Ex:
    If I want to view data in both databases at a time then query would be like the following:

    dblink name : SqltoOraclelink
    table Name : EMP (this could be available in both the databases)

    query in MsSqlServer200 EnterpriseManger:
    select empname, empno from EMP msemp, emp@SqltoOracle oraemp where msemp.empname = oraemp.empname

    Then this query results the rows from both the databases where empname is same in both the tables

    My question is: How can I create this Database link "SqltoOraclelink" as I can do the same thing in Oracle.

    As this is in urgency, it would be greate if somebody help us asap.

    Thanks in Anticipation,
    Regards,
    RK

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •