ASP on Windows 2016. Connection to DB Oracle raises error 3706 - Provider cannot be found

Question

I am migrating an old ASP (vbscript) application from a Windows 2003 server into a Windows 2016 64Bit server, where DB Oracle 18.0 is also installed.
Application uses ORAOLEDB.ORACLE provider to connect to DB. This is the code snippet used to get connection

Dim con, rs
set con = CreateObject("ADODB.Connection")
con.open ="provider=oraoledb.oracle;user id=xxx;password=yyy;data source=MyDB"
if err.number <> 0 then
    response.write "error<br>" & err.number & " - " & err.Description 
else
    response.write "connessione aperta"
end if
set rs = createobject("adodb.recordset")

rs.open "select count(*) as cnt from tgmi014 where yea=2020",con
response.write "found " & rs.fields(0).value & " items"
rs.close
set rs=nothing
con.close
set con=nothing

when executing con.Open, application crashes returning the above error message (3706 Provider cannot be found. It may not be properly installed)

Im sure TNSNAMES.ORA is correctly configured; in fact I can connect to DB via SQLPlus. I also tried to install ODAC 19.3 64Bit driver, and after registering ORAOLEDB19.DLL, ODAC connects to DB.

I also copied code snippet into a testdbconn.vbs file, and executed "cscript.exe testdbconn.vbs" from dos shell, getting the expected output.

Despite of all, ASP page fails. In IIS, I set Application Pools enabled to run 32Bit applications, but every test was unsuccessful.

ASP code was working on old Windows2003 server, whereas no ODAC was installed, so I suppose theres something on IIS to be set for it to work on Windows2016. How can I fix it?

thanks for help

Answer 1

You need to install the 32 bit driver

https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html

Answer 2

you are using the com based adodb driver. see:

http://docs.openlinksw.com/uda/lite/lite_oledb/