May 16, 2008 at 4:58 am
I need to set up a database link in oracle that lets me query data in sql server 2000 and sql server 2005.
I've got odbc connections for both sql server and oracle databases set up.
I know how to type the create database link command.
What I don't know is how to set up the tnsnames.ora and listener.ora files so the database link will find the right sql server database.
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!
May 28, 2008 at 6:54 pm
I don't think you will be able to do this link. From SQL Sever you can create a linked server to Oracle; but, from Oracle you will probably need the Oracle Gateway product. I could be wrong; but, nobody has attempted an answer in twelve days, so I respond with what I think I know. I spent several hours investigating Gateways and how they work, and at one point an Oracle consultant mutters something about ODBC; but, he was unable to provide details, or a link to a technical document. Granted, if it could be done with ODBC, it would cost him a potential sale... so the information may have not been at all valuable. If you get it working, please tell me how. There are hundreds of hits on "tnanames.ora" on google, if what you really need is syntax... and there are a couple of possible examples of syntax based on how the listener and sqlnet are set up... but, I don't believe that is your problem. Good luck!
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
May 29, 2008 at 12:29 pm
Here is a link that describes how to set up what you want to do.
http://www.databasejournal.com/features/oracle/article.php/3442661
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply