create link between SQLSERVER2000 & oracle 9.2.0.5
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: create link between SQLSERVER2000 & oracle 9.2.0.5

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    Question create link between SQLSERVER2000 & oracle 9.2.0.5

    Hi,

    I am asked to setup access from Oracle 9.2.0.5/Solaris for user abc to access the view xyz which is on SQL server2000/windows 2000 machines.

    Can anybody help me out ?

  2. #2
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by zakriyamhd
    Hi,

    I am asked to setup access from Oracle 9.2.0.5/Solaris for user abc to access the view xyz which is on SQL server2000/windows 2000 machines.

    Can anybody help me out ?

    Follow the steps:
    1. create an entry in tnsnames and listener to connect to the remote SQL server host, and the Kind of Heterogeneous services you choose - Transparent gateways or Generic connectivity initfile for TG4MSQL. Refer metalink docs 231458.1 & 252364.1

    2. create an ODBC connection pointing to the remote SQL server with the user credentials in Oracle server.

    3. create a DBlink with the user name and password to connect to the remote SQL server database from the schema you want to connect.

    now you can connect to the remote server and view xyz.

    I dont think you need separate license for this.
    "What is past is PROLOGUE"

Posting Permissions

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


Click Here to Expand Forum to Full Width