如果使用Microsoft ODBC for Oracle 连接Oracle 数据库，是否还需要安装Oracle Client？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1272998/
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
Do I Still Need To Install Oracle Client if Using Microsoft ODBC for Oracle to connect to an Oracle Database?
提问by Saobi
Using ActiveX Data Objects 2.8 Library as a Reference from Excel VBA, and the connection string is:
使用 ActiveX 数据对象 2.8 库作为 Excel VBA 的参考，连接字符串为：
"Driver={Microsoft ODBC for Oracle}......."
“驱动程序={Microsoft ODBC for Oracle}.......”
And I also have the "Microsoft ODBC for Oracle" (MSORCL32.dll) entry in the Drivers tab of Windows XP's ODBC Manager.
而且我在 Windows XP 的 ODBC 管理器的驱动程序选项卡中还有“Microsoft ODBC for Oracle”(MSORCL32.dll) 条目。
Now, will I be able to connect to an oracle databse, without any oracle client/products installed on my machine?
现在，我是否能够连接到 oracle 数据库，而无需在我的机器上安装任何 oracle 客户端/产品？
回答by Steve Broberg
I'm pretty sure you need to install Oracle client; what's more, I believe it has to be Oracle 8 Client (MS hasn't updated that driver in years, as far as I know).
我很确定您需要安装 Oracle 客户端；更重要的是，我相信它必须是 Oracle 8 Client（据我所知，MS 多年来没有更新该驱动程序）。
But have you tried using Oracle Instant Client? It's pretty painless to install, way, WAY smaller than the standard Oracle client and doesn't interfere with other installations. All you need to do is copy the files to a target directory, set your PATH to include that directory (which can be done inside your app - no need to actually set global PATH if you don't want to), and insert the appropriate registry entry into HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. We use it for all our ADO clients.
但是您尝试过使用Oracle Instant Client吗？安装起来非常轻松，比标准 Oracle 客户端小得多，并且不会干扰其他安装。您需要做的就是将文件复制到目标目录，将 PATH 设置为包含该目录（可以在您的应用程序中完成 - 如果您不想，则无需实际设置全局 PATH），然后插入适当的HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI 中的注册表项。我们将它用于我们所有的 ADO 客户。
It also has the added bonus of not requiring the maintenance of a TNSNAMES.ORA file; your connect string can simply be user/password@server:port/SID.
它还具有不需要维护 TNSNAMES.ORA 文件的额外好处；您的连接字符串可以简单地为 user/password@server:port/SID。
回答by Sathyajith Bhat
You will need the Oracle client. I had tried this out yesterday, on trying to connect ODBC driver yells back at me, "Oracle client is not installed".
您将需要 Oracle 客户端。我昨天试过这个，在尝试连接 ODBC 驱动程序时对我大喊“未安装 Oracle 客户端”。
回答by Sathyajith Bhat
there are other ODBC drivers out there that don't use the Oracle client software. DataDirect supply one https://www.progress.com/odbc/oracle-database
还有其他不使用 Oracle 客户端软件的 ODBC 驱动程序。DataDirect 提供一个https://www.progress.com/odbc/oracle-database
TLMC
TLMC
