SQLTeam.com | Weblogs | Forums

Linkedserver error. Oracle from SQL Server

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,

check this