http://download-west.oracle.com/docs/cd/A8...admin.htm#15089
Getting a db-link between Oracle and SQL Server is not hard:
1- Install ODBC
2- Setup tnsnames.ora for odbc connectivity (authentication=none)
3- Create db-link
1 and 3 are easy.
2 is a mystery. I'll have to do this with both sqlserver 2000 and sqlserver 2005 if that makes a difference.
Let's suppose my sql server machine name is "DAVID".
My Sql Server instance name is "DAVID\MYSQLSERVER".
The Sql Server catalog I want to connect to is "MYCATALOG".
The user id and password are "MYUSER" and "MYPASSWORD" respectively.
My oracle tns listener port is 1521.
My sql server port is 1433.
Could some kind soul show me an example tnsnames.ora and listener.ora and (if needed) sqlnet.ora entry to make this connection. I've already worked 70 hours this week and I don't want to spend my weekend guessing!
Thanks