Results 1 to 3 of 3

Thread: Using Oracle 9i to connect to SQL Server 2000 (Part 2)

  1. 05-11-2005, 10:02 AM #1
    warrentyler
    warrentyler is offline Registered User
    Join Date
    May 2005
    Location
    Dallas,TX.
    Posts
    3

    Using Oracle 9i to connect to SQL Server 2000 (Part 2)

    Hi,

    Here is the same question about the first post but related to a different operating system..How can you use Oracle 9i (Linux OS) to connect to and query a SQL Server database (Windows 2003 Server OS). It would have to query the SQL Server database then possibly load the result set back into the Oracle database. Any thoughts on how to accomplish this will be appreciated.

    Thanks,

    Warren
    Reply With Quote Reply With Quote
  2. 05-11-2005, 03:24 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Transparent Gateway for SQL Server again.

    You have to buy this product. However if your need can be met by pushing data from SQL Server to Oracle then you can use linked server from SQL Server to Oracle server and it's free.
    Reply With Quote Reply With Quote
  3. 05-11-2005, 03:28 PM #3
    warrentyler
    warrentyler is offline Registered User
    Join Date
    May 2005
    Location
    Dallas,TX.
    Posts
    3
    Thanks! I will use the Oracle Heterogeneous Services.

    Thanks Again!
    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