Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Link server issue

Chanchal WankhadeFeb 10 2013 — edited Feb 10 2013
Dear All,

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.




Thansks.

Comments

Girish Sharma
I found couple of good link when I said "access oracle database from sql server 2008" to google like :

1.http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005

2.http://www.sqlmag.com/article/oracle/connecting-sql-server-and-oracle-using-linked-servers-102313

3.http://www.dotnetfunda.com/forums/thread3238-connection-between-oracle-server-and-sql-server-2008.aspx

Just try to follow and let us know, if they help you.

Regards
Girish Sharma
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2013
Added on Feb 10 2013
#general-database-discussions
1 comment
787 views