What do I need to install to use OraOLEDB

Question

I have a Delphi 2007 app using ADO to connect to an Oracle database. I have found for the app to support Blob field types I need to use the OraOLEDB provider to connect. The connection string:

Provider=OraOLEDB.Oracle;Password=pwd;User ID=username;Data Source=127.0.0.1;Persist Security Info=False

I have found that using MSDAORA.1 as the provider, while it works with all other database communication, does not work with the Blob field.

My question is, what do I need to install to have OraOLEDB installed/supported? Is there a specific DLL that needs to reside?

I have found the typical Oracle client installation is not supporting OraOLEDB. It errors when trying to connect to the database because OraOLEDB is not installed.

Answer 1

Download OraOLEDB_90101.exe and run it. The full instructions are Instructions for Installing Oracle Provider for OLE DB . If you do some searching on MSDN they say that BLOB data is not supported with the Microsoft data provider, MSDAORA.1