none
Run ASP on Windows Server 2008 R2 connecting Oracle DB RRS feed

  • Question

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

    Tuesday, October 26, 2010 10:29 AM

Answers

  • Use ODAC 11.2.0.1.2 (Oracle Provider for OLE DB) with correct tnsnames.ora file definition + In IIS 7.5 Server Manager – Roles – Web Server – IIS (IIS Manager) -- Connections – +ServerName+– ApplicationPools – DefaultAppPool -- Advanced Settings – Enable 32-bit Applications = TRUE (this enable *.udl files for asp pages)
    • Marked as answer by Deardeer Friday, February 4, 2011 1:39 PM
    Friday, February 4, 2011 1:39 PM