tags:

views:

198

answers:

1
+2  Q: 

What do I need to install to use OraOLEDB

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.

+1  A: 

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

Philip Schlump  2009-12-11 03:15:57
will give this a try with my customer tomorrow - will let you know.
M Schenkel  2009-12-11 05:01:07
Where do you download the file?? I was just on the Oracle site and searched for OraOLEDB_90101.exe. Could not find a link to download this file.
M Schenkel  2009-12-11 05:07:15
disregard - google searching did better job than Oracles against their own site:http://www.oracle.com/technology/software/tech/windows/ole_db/htdocs/utilsoft.htm
M Schenkel  2009-12-11 05:09:51
Google is WAY WAY better at search than Oracle! Sorry it took me so long to get back and check for comments on this.
Philip Schlump  2009-12-11 05:17:42
It actually turned out to be this file: http://www.oracle.com/technology/software/tech/windows/ole_db/htdocs/utilsoft.htm The client for Oracle 10g. Thank you for your assistance.
M Schenkel  2009-12-14 21:54:30

related questions

Is there a Way to use Linq to Oracle
NHibernate and Oracle connect through Windows Authenication
Boolean Field in Oracle
How do you manage schema upgrades to a production database?
How do I deal with quotes ' in SQL
When do you use table clusters?
Oracle write to file
MS SQL Server 2008 "linked server" to Oracle : schema not showing
Develop on local Oracle instance
Resources for an Oracle beginner
What strategies have you employed to improve web application performance?
Automate Syncing Oracle Tables With MySQL Tables
Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?
What Content Management does your workplace use?
What is the difference between oracle's 'yy' and 'rr' date mask?
SQL/Query tools?
How to make Pro*C cope with #warning directives?
Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)
How big would such a database be?
Oracle - What TNS Names file am I using?
What is a good way to open large files across a WAN?
How do I find the high water mark (for sessions) on Oracle 9i
SQL Case Statement Syntax?
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?