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?
I want to connect it from a different system/environment like SQL Server is one system and Oracle Db in an other system. I want communicate with both two system. Is that Possible?
The Oracle OLEDB driver requires just the Oracle client software which then allows you to connect to any Oracle database. So what you need is to install on the SQL Server the Oracle client software and the OLEDB driver (which is part of the client installation).
As this forum is commonly handling connections from an Oracle database to a SQL server database with the Oracle database as the driving site. You are going to connect from a SQL Server to Oracle using OLED so you'd better post your request in the OLEDB forum if you need more details, here the link: Oracle Provider for OLE DB
Edited by: kgronau on Jul 18, 2012 9:55 AM
Just saw you already started in this forum a dedicated thread, so please close this one.