CODEWITHSUNDEEP
oracle-databaseasp-classicodbcconnection-string
Nime Cloud
Nime Cloud

Reputation: 6399

Oracle Ole DB drivers won't work: ADODB.Connection error '800a0e7a'

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:

This is the C:\Windows\System32\odbcad32.exe result

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

enter image description here

<%  
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.

enter image description here

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

Upvotes: 2

Views: 8830

Answers (1)

Nime Cloud
Nime Cloud

Reputation: 6399

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

enter image description here

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

Upvotes: 1

Related Questions