Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: How To Connect Oracle DB with Microsoft SQL Server

    Hello,

    Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!

    Thanks!

  2. #2
    Join Date
    Nov 2003
    Posts
    167
    I'm not sure which side you're connecting from (from mssql to oracle or vice versa), but a good starting point would be to look up linked servers in books online. MSHelp has a pretty good troubleshooter at http://support.microsoft.com/kb/280106/ .

    Good luck.
    Kit Lemmonds

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by lklp
    Hello,

    Does anyone know how to connect Oracle 10g DB to Microsoft SQL Server? If so, any tips or help would be greatly appreciated!

    Thanks!
    Things that I have done/would do in your place (not saying that they are right):

    1. Install Oracle 10g Client s/w on db server
    2. Create tnsnames entry(ies) using Oracle Net Manager

    Then, optionally:
    3a. Create a linked server and access Oracle through OPENQUERY and/or four-part naming convention
    3b. Create DTS package(s) to move data local to SQL Database

    Which path you choose (a or b) depends on your requirements and resources.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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