Hi,
I am trying to access Oracle database from SQL Server.
I installed ODAC also in source machine.
Created the Linked server in SQL Server Source server below.
Exec sp_addlinkedserver 'Test',Oracle,'OraOLEDB.Oracle','Oracedbservername:Port/OracleDB'
In Test Properties : Server Objects: I checked The "Use Remote Collection" to True.
Security : selected "Be made using this security context: Gave Remote login and password.
When i am testing the connection getting the error con not create n instance of OLEDB provider 'OraOLEDB.Oracle' for inked server "Test".(error:7302)
Please help me to resolve the issue. Its urgent.
Thanks,