oracle 我需要安装什么才能使用 OraOLEDB
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1884183/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What do I need to install to use OraOLEDB
提问by M Schenkel
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:
我有一个使用 ADO 连接到 Oracle 数据库的 Delphi 2007 应用程序。我发现应用程序支持 Blob 字段类型，我需要使用 OraOLEDB 提供程序进行连接。连接字符串：
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.
我发现使用 MSDAORA.1 作为提供程序，虽然它适用于所有其他数据库通信，但不适用于 Blob 字段。
My question is, what do I need to install to have OraOLEDB installed/supported? Is there a specific DLL that needs to reside?
我的问题是，我需要安装什么才能安装/支持 OraOLEDB？是否有需要驻留的特定 DLL？
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.
我发现典型的 Oracle 客户端安装不支持 OraOLEDB。尝试连接到数据库时出错，因为未安装 OraOLEDB。
回答by Philip Schlump
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_90101.exe 并运行它。完整的说明是安装 Oracle Provider for OLE DB 的说明 。如果您在 MSDN 上进行一些搜索，他们会说 Microsoft 数据提供程序 MSDAORA.1 不支持 BLOB 数据
