We have a user that needs to connect to an oracle database using Microsoft OLE DB Provider for Oracle
Printable View
We have a user that needs to connect to an oracle database using Microsoft OLE DB Provider for Oracle
It should be part of OS install, if not, then you need to download MDAC tool from Microsoft.
http://www.microsoft.com/downloads/d...displaylang=en
Oracle has its own ole db provider.
We use Oracles instant client, installed on the SQL server and then set up a linked server.
thanks all for your help.