找不到OLEDB.oracle提供程序 [英] OLEDB.oracle provider not found

问题描述

我在访问Oracle数据库的Excel VBA应用程序遇到了一个奇怪的问题.该应用程序在开发和测试中均能完美运行，但是当将其安装到VM上以供使用时，它表示找不到数据提供者，或者数据提供者可能未正确安装.

I am hitting a strange problem with an Excel VBA application that accesses an Oracle database. The application works perfectly in development and in test, but when it was installed on to a VM for support to use, it says that it cannot find the data provider or the data provider may not have been installed properly.

通常，问题是没有安装OLE数据库提供程序时就没有安装Oracle客户端，但这已全部安装并且没有任何阻塞. SQL Developer可以访问数据库，因此我对可能出现的问题感到困惑.

Normally, the issue would be that the Oracle Client hasn't been installed with the OLE Database Provider missing, but this is all installed and there is nothing blocking. SQL Developer can access the database, and so I am confused as to what the problem could be.

正在使用的是Oracle 12c Client，正如我所说-一切在开发和测试中都可以正常工作.

It is Oracle 12c Client that is being used, and as I said - everything is working fine in development and in test.

有人可以帮我这个忙吗?

Can someone throw some light on to this for me?

推荐答案

Excel 2010存在问题.一位同事安装了64位版本的Office 2010，而不是标准版本.安装此程序后，它可以工作.因此，在安装Office 2010时要小心

Problem was with Excel 2010. A colleague installed a 64bit version of Office 2010 rather than the standard version. When this was installed, it worked. So, be careful when installing Office 2010

这篇关于找不到OLEDB.oracle提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！