Results 1 to 4 of 4

Thread: Can we connet between Oracle and MSSQL?

  1. 12-12-2006, 11:55 PM #1
    dnguy3
    dnguy3 is offline Registered User
    Join Date
    Dec 2006
    Posts
    1

    Can we connet between Oracle and MSSQL?

    Hi Expertises,

    I am having question would like to know the answer:
    Can we connect 02 DB Oracle and MSSQL then get data from both of them?
    Thanks,
    Reply With Quote Reply With Quote
  2. 12-13-2006, 11:07 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can create linked server on MS sql to point to Oracle.
    Reply With Quote Reply With Quote
  3. 12-13-2006, 11:26 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    You could use the following in sql server to connect to oracle and get data.
    Linked server and openquery
    or
    openrowset
    or
    opendatasource
    or
    DTS
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 12-13-2006, 12:24 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can do other way around too. You can use Heterogenous services setup to connect to SQL Server from Oracle. It involves modifying odbc file under hs folder in oracle home, then creating a dblink.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules