当安装32位和64位客户端时，获取MS Office 2013（32位）Excel和Access连接到Oracle数据库 [英] Getting MS Office 2013 (32 bit) Excel and Access to connect to Oracle database when both 32 and 64 clients are installed
问题描述
在我的机器上安装了Oracle 11gr2的32位和64位客户端之后，我对Microsoft Office产品有一些问题。我目前正在运行Windows 7 64位与Microsoft Office 32位。
I am having some issues with Microsoft Office products after installing both the 32 bit and 64 bit clients for Oracle 11gr2 on my machine. I'm currently running Windows 7 64 bit with Microsoft Office 32 bit.
我们依赖于32位应用程序，正在与一群人合作 - 其中大多数人有32位OS机器，所以我需要运行Office 32位。
We are dependent on some 32 bit applications and are working with a team of people - most of whom have 32 bit OS machines, so I need to run Office 32 bit.
目前，我正在创建和维护一些我们的员工使用的支持Excel的工作簿访问数据库的信息。访问数据库使用sqora32.dll驱动程序连接到oracle，并使用oraclient11.dll连接excel工作簿。
Currently, I'm creating and maintaining some Excel macro-enabled workbooks that our staff uses to submit information to access databases. The access databases make connections to oracle using the sqora32.dll driver and the excel workbooks connect using oraclient11.dll.
我最近收到了一个ArcGIS Pro的构建，它需要一个64位oracle客户端，并且已经在我们的生产车间进行了测试。我以为我已经成功安装了64位oracle即时客户端（我拥有32位oracle客户端的完整管理员版本），因为一切都很好。我的32位软件的其余部分连接正常。但是，当我尝试通过访问进行oracle连接时，驱动程序失败或者我得到一个kernelbase错误，Access完全崩溃。
I recently got a build of ArcGIS Pro, which requires a 64 bit oracle client and have been testing it for use on our production floor. I thought I had successfully installed the 64 bit oracle instant client (I have the full administrator version of the 32 bit oracle client) because everything worked great. The rest of my 32 bit software connects fine. However, when I try to make an oracle connection through access, the driver fails or I get a kernelbase error and Access completely crashes.
当我通过Excel vba尝试查询，我从Oracle ODBC驱动程序中收到错误。它说，内部错误 - 无法在驱动程序加载期间初始化NLS。我的事件日志显示oraclient11.dll失败。当我尝试使用以管理员身份运行连接时，应用程序不会完全崩溃，他们只是停止工作。
When I try the query through Excel vba, I get an error from the Oracle ODBC Driver. It says, Internal Error - unable to initialize NLS during driver load. My event log shows the oraclient11.dll failing. When I try connecting using the "Run as administrator" option, the applications don't completely crash, they just stop working.
我已经尝试卸载并重新安装32位oracle客户端，设置oracle_home环境变量，使用c：\\\\windows\system32中的软链接进行解决，并更改PATH环境变量中条目的顺序，并设置NLS_LANG环境变量。
I've tried uninstalling and reinstalling the 32 bit oracle client, setting oracle_home environment variable, a work-around using softlinks in c:\windows\system32 and changing the order of the entries in the PATH environment variable, and setting the NLS_LANG environment variable.
我真的很想弄清楚，而无需找到另一台机器来测试Pro。有人可以帮我吗？因为我的32位软件正确连接，我认为这与Office尝试使用64位驱动程序有关，但我不是专家。所以，我不知道。
I would really like to figure this out without having to find another machine to test Pro on. Can anyone help me out with this? Because my 32 bit software is connecting correctly, I think it has something to do with Office trying to use the 64 bit drivers, but I'm not an expert on this. So, I don't know.
任何帮助都将非常感激。如果以前已经回答过，可以提供一个链接吗？我一直在搜索这个上周的大部分时间到今天，并没有找到任何解决我的特殊问题。
Any help would be very much appreciated. If this has been answered before, can you please provide a link? I've been searching this for most of last week through today and have been unable to find anything that addresses my particular issue.
推荐答案
我有一个类似的问题，尝试使用Teradata ODBC连接，我必须通过实际指定dll所在的位置进行修复。我的连接字符串最后看起来像这样。由于不同的问题，我放弃了使用DSN的名称。
I had a similar issue trying with a Teradata ODBC connection that I had to fix by actually specifying where the dll was located. My connection string ended up looking something like this. I gave up on trying to use DSN names as well due to a different problem.
ODBC;DefaultDir=C:\Program Files (x86)\Teradata\Client\14.10\ODBC Driver for Teradata\Lib\tdata32.dll;DRIVER={Teradata};DBCName=ourserver.com;
这篇关于当安装32位和64位客户端时，获取MS Office 2013（32位）Excel和Access连接到Oracle数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
