Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    13

    Unanswered: Using Oracle to read from SQL 2000

    I am using Oracle 8.0.5

    I now need to link and read data from a table on an SQL 2000 database.

    What must I do?

    Both servers are win2000 and are on same network.

  2. #2
    Join Date
    Sep 2003
    Location
    Milan, Italy
    Posts
    130
    There's an Oracle product called 'Transparent Gateways' that can do that - but i've never used it myself. On otn.oracle.com there should be a lot of infos.

    Basically it lets you create a special type of db-link from Oracle to SqlServer, and then the table appears as it were an Oracle table.

    If the table is static (never changed), you may also want to copy it into the Oracle database - much more performant for sure ...

    HTH
    Al

  3. #3
    Join Date
    Jan 2004
    Posts
    13
    Thanks Alberto

    I am glad that you confirmed it is possible, as I was starting to doubt it.
    I will take a look at otn and see what I can find.

    But in meantime if anyone else has done this before your input would be welcome.

  4. #4
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Using Oracle to read from SQL 2000

    Originally posted by jambor
    I am using Oracle 8.0.5

    I now need to link and read data from a table on an SQL 2000 database.

    What must I do?

    Both servers are win2000 and are on same network.
    This document try the theme about transparent gateways:
    Heterogeneous Connectivity Administrator's Guide Contents / Search / Index / PDF
    http://download-east.oracle.com/docs...920/a96544.pdf

    Oracle9i Database List of Books
    (Release 2 (9.2))
    http://otn.oracle.com/pls/db92/db92....emark=homepage
    Joel Pérez

Posting Permissions

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