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!

How to connect/retrieve data from Oracle DB in SQL DB

949559Jul 16 2012 — edited Jul 16 2012

Hi All,

i successfully connected and retrieved data from Oracle Db in SQL-Server using linked Server .Right now, I have configured oracle Db (10 g) and SQL server 2008 both in the same system, but i want to connect it from a different system/environment. Is that possible, if yes can you tell me how??

And one more thing. When i actually install oracle in the system which also had SQL server, i obtained the provider 'oraOLEDB.Oracle'. While i see that it was obtained because i installed in the same system, how do i achieve that when i install it in a remote system. Or how do i connect to the remote system having Oracle through some other means?

Kindly help me on this.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2012

Added on Jul 16 2012

#general-database-discussions

1 comment

58 views