January 24, 2010 at 2:23 am
Hello Everyone,
Here i have Oracle Database 9i and SQL Server 2005 databases.
I have some tables in sql server db and i want to access from Oracle.
How to create a link between these two servers
please do needful.........
Kindly waiting for the replay...
Thanks,
January 25, 2010 at 7:25 am
I did this at my last job. Since I'm no longer there, I don't have complete details, but here are some general steps. And I'm a SQL Server guy, so my Oracle is not exactly the best.
1. download and install the Oracle 9i client. I think it's free from Oracle.
2. configure client using Net Manager. We used the tnsnames.ora file, but there is another way to talk to Oracle.
3. verify your connectivity to Oracle using Net Manager
4. create a linked server in SQL Server (Server Objects - Linked Servers). Not sure what the Provider name will be, since I don't have Oracle drivers installed here.
From there, it's pretty much the same as configuring any other linked server.
Good luck....
Peter
January 25, 2010 at 8:28 am
Peter Veilleux-436764 (1/25/2010)
I did this at my last job. Since I'm no longer there, I don't have complete details, but here are some general steps. And I'm a SQL Server guy, so my Oracle is not exactly the best.1. download and install the Oracle 9i client. I think it's free from Oracle.
2. configure client using Net Manager. We used the tnsnames.ora file, but there is another way to talk to Oracle.
3. verify your connectivity to Oracle using Net Manager
4. create a linked server in SQL Server (Server Objects - Linked Servers). Not sure what the Provider name will be, since I don't have Oracle drivers installed here.
From there, it's pretty much the same as configuring any other linked server.
Good luck....
Peter
Provider should be Microsoft OLE DB Provider for Oracle.
January 25, 2010 at 11:22 pm
Thanks for the reply,
Where i need to install oracle client software ??
in SQL server or Oracle Server
We have both servers & databases...
I need to access the tables of sql server database from oracle......
Thanks,
January 25, 2010 at 11:37 pm
Try these links
Connect to SQL Server from Oracle
Connect to SQL Server from Oracle with screenshots
I am not an Oracle guy but I read this article few months back.
January 27, 2010 at 12:23 pm
Ram,
You should install Oracle Client on your development machine (similar to SQL Native Client installation). One thing to remember is that Oracle Client installation creates system variables and sometimes skips an important BIN folder. Without BIN folder SSIS/SQL Server can't find essential Oracle drivers/DLLs.
Good luck,
Steve.
January 28, 2010 at 5:19 am
I thought the question was how to connect to SQL Server From Oracle.
January 28, 2010 at 11:24 am
vstitte,
You're probably right, but I figured they will use SSIS for data-exchange anyway. If that is the case then my post is relevant, otherwise my post was for PR purposes only. 😛
- Steve.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply