I would like to connect oracle database to sql server 2005 and i installed oracle client and also used the following queries to create a linked server
1.sp_addlinkedserver ‘AGRICULTS’, ‘Oracle’,
2.sp_addlinkedsrvlogin ‘AGRICULTS’, false, NULL, ‘user’,
The linked server is created but when i try to run my query in sql server 2005 i get the following error:
The OLE DB provider “OraOLEDB.Oracle” has not been registered.
please help on this issue. Thanks.