带有 OraOLE DB 提供程序的 Oracle 即时客户端？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/166270/
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
Oracle instant client with OraOLE DB provider?
提问by yesraaj
Is it possible to use oracle instant client for application that use oraoledb driver for connecting to oracle 9i DB.
是否可以将 oracle 即时客户端用于使用 oraoledb 驱动程序连接到 oracle 9i DB 的应用程序。
采纳答案by Justin Cave
I don't believe so. The Instant Client FAQstates
我不相信。的即时客户端常见问题状态
What can Instant Client be used for? Instant Client can be used to run your OCI, OCCI, ProC, JDBC, and ODBC applications without installing a full Oracle Client. In addition, Instant Client supports SQLPlus. As of Instant Client 10.2, it is also possible to develop applications for OCI and OCCI using the Instant Client SDK download.
Instant Client 可以用来做什么？Instant Client 可用于运行 OCI、OCCI、Pro C、JDBC 和 ODBC 应用程序，而无需安装完整的 Oracle 客户端。此外，Instant Client 支持 SQLPlus。从 Instant Client 10.2 开始，还可以使用 Instant Client SDK 下载为 OCI 和 OCCI 开发应用程序。
OLE DB is conspicuously absent from that list. Now, potentially, you could use the Microsoft OLE DB to ODBC provider along with the Instant Client and ODBC, but adding additional layers to software is never very fun.
OLE DB 明显不在该列表中。现在，您可能会使用 Microsoft OLE DB 到 ODBC 提供程序以及 Instant Client 和 ODBC，但是向软件添加附加层从来都不是一件很有趣的事情。
回答by Baumann
I think it is possible. Look for Oracle Data Access Components (ODAC). I've downloaded the ODAC XCopy version, then:
我认为这是可能的。查找Oracle 数据访问组件 (ODAC)。我已经下载了ODAC XCopy 版本，然后：
- unzip on some tmp folder
- open cmd as administrator
- run install.bat (I've run:
install oledb c:\oracle\odac_12_1 odac true)
- 解压到某个 tmp 文件夹
- 以管理员身份打开cmd
- 运行INSTALL.BAT（我已经运行：
install oledb c:\oracle\odac_12_1 odac true）
Despite being on this script, the command regsvr32(to register the oraoledb12.dll, in my case) didn't work. But running this command after the script worked. Check the PATH variable as well because the script could only change it for the prompt session.
尽管在这个脚本上，命令regsvr32（oraoledb12.dll在我的例子中注册）不起作用。但是在脚本运行后运行此命令。还要检查 PATH 变量，因为脚本只能为提示会话更改它。
Now I'm being able to connect to a Oracle DB using OraOLEDB.Oracle providerand Oracle Instant Client.
现在我可以使用OraOLEDB.Oracle provider和Oracle Instant Client连接到 Oracle DB 。
