Results 1 to 2 of 2

Thread: To Join Oracle Table in query of MS SQL

  1. 04-06-2004, 11:23 AM #1
    lakshmish
    lakshmish is offline Registered User
    Join Date
    Apr 2004
    Posts
    1

    To Join Oracle Table in query of MS SQL

    I have an app build and running on MS SQL Server.
    I have a need to use one ORACLE TABLE.
    Curious to know whether I have a way to use Oracle table in the Query written in MS SQL Server (need to select few columns from this Oracle table, and also have to Join with SQL Server table).

    Do I have something like Link a table, that I have in MS Access.

    Thanks
    Laks
    Reply With Quote Reply With Quote
  2. 04-06-2004, 12:21 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can setup Linked Server from SQL Server to Oracle.

    If it is a one time thing, then you can use OPENDATAROWSET function to get data from Oracle.

    For it to work, you need to install Oracle client in your SQL Server, configure Net80 and reboot SQL Server.

    If you don't want to do that, then you can use DTS to pull data in a temporary database and join it locally.
    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