Oracle Ole DB驱动程序将不起作用:ADODB.Connection错误'800a0e7a'

本文介绍了Oracle Ole DB驱动程序将不起作用:ADODB.Connection错误'800a0e7a'的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我已经在Windows Server 2008 Standard上安装了三个客户端程序包，但是由于错误找不到提供程序"而仍然无法打开连接.所有这些软件包都是针对64位的.

C:\ Windows \ System32 \ odbcad32.exe屏幕截图:

c:\ windows \ SysWOW64 \ odbcad32.exe屏幕截图:没有ORACLE驱动程序！

 <％设置conn = Server.CreateObject("ADODB.Connection")打开"Provider = OraOLEDB.Oracle; Password = XXXX; Persist Security Info = True; User ID = XXXX; Data Source = XXXX"％>

当我运行代码时，它给出了一个错误:

我也阅读了类似的问题，做了建议，但我被这个错误困住了.

还启用了32位应用程序池.

连接字符串帮助页面:

下载并安装ODAC.

I've installed three of the client packages on Windows Server 2008 Standard but still cannot open a connection because of the error "Provider not found". All of these packages are for 64bit.

C:\Windows\System32\odbcad32.exe screenshot:

c:\windows\SysWOW64\odbcad32.exe screenshot: NO ORACLE DRIVER!!!

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"
%>

When I run the code, it gives an error:

I've also read similar questions and did what they suggest but I'm stuck at this error.

32bit app pool is also enabled.

Connection string help page: http://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/

Oracle 11g release 2 client ODBC drivers link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

解决方案

Oracle Provider for OLE DB should be installed and OraOLEDB12.DLL should be registered. You can use free RegDllView utility from NirSoft to examine.

Download and install ODAC.

这篇关于Oracle Ole DB驱动程序将不起作用:ADODB.Connection错误'800a0e7a'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！