We have Install:-
Windows server 2008, 64 bit.
MS SQL Server 2008.
Oracle 11g client, 64 bit.
odac 11g 64 bit.
We have oracle 10g on our live server that is alos on 2008, 64 bit.
Our requirment is to access oracle view from oracle 10g database to MS SQL server database. For that we have install all the above things.
But oracle is not visible while in the link server. To add link server we are following below steps,
In SQL server database Right click on link server, add link server but it does not show any oracle link.
We have install oracle client first and then ODAC.
are we missing any steps to add link server in SQL Database.
I found couple of good link when I said "access oracle database from sql server 2008" to google like :
Just try to follow and let us know, if they help you.