Geek Answers Handbook

What do I need to install to use OraOLEDB

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

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

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

My question is: what do I need to install to install / support OraOLEDB? Is there a particular dll that should be located?

I found that a typical Oracle client installation does not support OraOLEDB. These are errors when trying to connect to the database because OraOLEDB is not installed.

+5
source share
1 answer

Download the OraOLEDB_90101.exe file and run it. Complete instructions Installation instructions for the Oracle provider for OLE DB . If you search on MSDN, they say that BLOB data is not supported by Microsoft data provider, MSDAORA. 1

+1
source

More articles:


All Articles