Anyone know how to load the Oracle Provider for OLEDB... not the Microsoft Oracle Provider for OLEDB... so it shows as an option in the drop down list for the Linked Server Properties Provider drop down list? Or maybe if I use sp_addlinkserver ?. How may I obtain the Oracle Provider needed to create a linked server to an Oracle DB. Thanks for everyone for being there to help.
Install the Oracle client - I think the 8.4 client and newer includes a complete OLEDB provider. They are not 100% OLEDB compliant (even the 10g client is not).
You need to install the Oracle client to use the MS provider as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply