Oracle Ole DB驱动程序将不起作用:ADODB.Connection错误'800a0e7a' [英] Oracle Ole DB drivers won't work: ADODB.Connection error '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"％> 当我运行代码时，它给出了一个错误:
ADODB.Connection错误'800a0e7a'
找不到提供者.
我也阅读了类似的问题，做了建议，但我被这个错误困住了.
还启用了32位应用程序池.
连接字符串帮助页面:
下载并安装ODAC.
适用于OLE DB 64位ODAC 12c第4版(12.1.0.2.4)的Oracle提供程序Windows x64
[2015年10月5日发布]
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
在IIS应用程序池中禁用32位支持.
重启
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:
ADODB.Connection error '800a0e7a'
Provider not found.
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 Provider for OLE DB 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
[Released October 5, 2015]
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
Disable 32bit support in IIS application pool.
Reboot
这篇关于Oracle Ole DB驱动程序将不起作用:ADODB.Connection错误'800a0e7a'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
