This discussion is archived
0 Replies Latest reply: Jul 17, 2012 11:45 PM by 949559 RSS

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

949559 Newbie
Currently Being Moderated
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

Edited by: Dhanavel on Jul 17, 2012 11:43 PM

Edited by: Dhanavel on Jul 17, 2012 11:45 PM

Edited by: Dhanavel on Jul 17, 2012 11:45 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points