难道我还需要安装Oracle客户端，如果使用Microsoft ODBC对Oracle连接到Oracle数据库？ [英] Do I Still Need To Install Oracle Client if Using Microsoft ODBC for Oracle to connect to an Oracle Database?

问题描述

使用ActiveX数据对象2.8库从Excel中VBA参考，并连接字符串：

Using ActiveX Data Objects 2.8 Library as a Reference from Excel VBA, and the connection string is:

驱动程序= {微软ODBC的Oracle} ......。

"Driver={Microsoft ODBC for Oracle}......."

和我也有在Microsoft ODBC的Oracle（MSORCL32.DLL）在Windows XP中的ODBC管理器的驱动程序选项卡项。

And I also have the "Microsoft ODBC for Oracle" (MSORCL32.dll) entry in the Drivers tab of Windows XP's ODBC Manager.

现在，我将能够连接到Oracle DATABSE，没有任何Oracle客户端安装在我的机器上/产品？

Now, will I be able to connect to an oracle databse, without any oracle client/products installed on my machine?

推荐答案

我是pretty的确定需要安装Oracle客户端;更重要的是，我相信这是甲骨文8客户端（MS还没有更新的驱动程序来，据我所知）。

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即时客户端？这是pretty的无痛安装，方式，方法比标准的Oracle客户端小，不与其它的设备产生干扰。所有你需要做的就是将文件复制到目标目录，设置PATH，以包括目录（可以在你的应用程序中完成 - 无需实际设置全局路径，如果你不想），并插入相应的注册表项到HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST.INI。我们用它为我们所有的客户ADO

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.

它也具有不需要TNSNAMES.ORA文件的维护额外的奖励;您的连接字符串可以简单地将用户名/密码@服务器：端口/ SID

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.

这篇关于难道我还需要安装Oracle客户端，如果使用Microsoft ODBC对Oracle连接到Oracle数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！