我需要安装才能使用OraOLEDB [英] What do I need to install to use OraOLEDB

问题描述

我有一个使用ADO连接到Oracle数据库的Delphi 2007应用程序。我发现应用程序支持Blob字段类型，我需要使用OraOLEDB提供程序进行连接。连接字符串：

  Provider = OraOLEDB.Oracle; Password = pwd;用户ID =用户名;数据源= 127.0.0.1; Persist Security Info = False 
  

我发现使用MSDAORA.1作为提供者，所有其他数据库通信不适用于Blob字段。

我的问题是，我需要安装OraOLEDB才能安装/支持？有没有特定的DLL需要驻留？

我发现典型的Oracle客户端安装不支持OraOLEDB。尝试连接到数据库时出现错误，因为OraOLEDB未安装。

解决方案

下载OraOLEDB_90101.exe并运行它。完整的说明是安装Oracle提供程序的OLE DB说明
。如果您在MSDN上进行某些搜索，则表示Microsoft数据提供商不支持BLOB数据，MSDAORA.1

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.

解决方案

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

这篇关于我需要安装才能使用OraOLEDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！