Hello,
I have following problem. I cannot run the ASP files where I got the error message:
Microsoft OLE DB Service Components error '80040154'
Class not registered
My Installation:
Windows Server 2008 R2 (64-bit)
Microsoft SQL Server Standard Edition (64-bit)
ODAC 11.2 (64-bit)
With ODAC 11.2 installation I succeeded to get "Oracle Provider for OLE DB" in the list of Provider in window box "Data Link Properties" and I successfully set up the connection to data. After click on button "Test Connection"
I get the alert box "Microsoft Data Link" with message "Test connection succeeded". While I am trying to set up the connection in ASP code link the working udl file:
<%
DIM sysconLDAP
Set sysconLDAP = Server.CreateObject("ADODB.Connection")
sysconLDAP.ConnectionString = "File Name=D:\web\connectLDAP.udl;"
sysconLDAP.Open
%>
I received the error mentioned above.
I have read a lot of articles, spent days online, but no thread lead to complete set up and 100% success.