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"