ASP db connection problem in IIS7RSS

16 replies

Last post Aug 07, 2019 08:53 PM by NedStark

  • ASP db connection problem in IIS7

    Aug 22, 2008 04:23 PM|AmitBu|LINK

    Hello!
    I've  recently installed vista on my computer, I'm an ASP programmer so I installed  IIS 7 .
     I can run classic ASP pages, but when the page is connected to Access data base an Error appears:
    ADODB.Connection error '800a0e7a'
    Provider cannot be found. It may not be properly installed.
    /Project/index.asp, line 6
     
    Can someone please help me?
    Thank you!
     

    vista db connection problem db connection problem in IIS7

  • Re: ASP db connection problem in IIS7

    Aug 22, 2008 06:46 PM|mukhtard|LINK

    Do you have MDAC installed?

    Thanks,
    Mukhtar Desai
    IIS Performance Team

  • Re: ASP db connection problem in IIS7

    Aug 22, 2008 07:20 PM|AmitBu|LINK

    mukhtard

    Do you have MDAC installed?

    Thanks,
    Mukhtar Desai
    IIS Performance Team

    I don't think so,

    But I tried to download it from the Microsoft website, and it said that it is not for vista...

  • Re: ASP db connection problem in IIS7

    Aug 22, 2008 07:40 PM|mukhtard|LINK

    Yes you are right MDAC is replaced by WDAC, see http://msdn.microsoft.com/en-us/library/ms692897.aspx .

    Can you send your code snippet that is making the connection?

    Thanks,
    Mukhtar Desai
    IIS Performance Team

  • Re: ASP db connection problem in IIS7

    Aug 22, 2008 07:46 PM|AmitBu|LINK

     Here is the connection code:


    set conn = Server.CreateObject("ADODB.Connection")
    conn.Open"Provider=Microsoft.Jet.OLEDB.4.0;Data source ="&Server.MapPath("admin/db/ILtv.mdb")
    set rs = Server.CreateObject("ADODB.Recordset")
    mySQL="select * from movie"
    rs.Open mySQL, conn,3,3

    (on windows XP pro it works fine..)

     And thanks for helping :)

  • Re: ASP db connection problem in IIS7

    Aug 22, 2008 09:42 PM|mukhtard|LINK

    From an elevated command prompt run the following command:

    regsvr32 "%CommonProgramFiles%\System\ado\msado15.dll"

    If this register's correctly, try running your application and see if it makes the connection. If this still fails, there are bunch of other files in the ado folder that you may want to register as well like msadox.dll and msadrh15.dll.

    If you are running 64-bit Vista and running your IIS worker process in Wow64 mode then you want to register these dlls from under the D:\Program Files (x86)\Common Files\System\ado folder.

    Thanks,
    Mukhtar Desai
    IIS Performance Team

  • Re: ASP db connection problem in IIS7

    Sep 16, 2008 01:44 PM|Kanien|LINK

     I have the same error and all of theese files have already been registered.  I looked through the registry to confirm.

     

    This is my error 

    ADODB.Connection error '800a0e7a'

    Provider cannot be found. It may not be properly installed.

    /global-concise.asp, line 247

     

  • Re: ASP db connection problem in IIS7

    Mar 28, 2009 03:56 AM|davidmills02|LINK

    I Tried your suggestion regsvr32 "%CommonProgramFiles%\System\ado\msado15.dll" and receive the message

    regsvr32 "%CommonProgramFiles%\System\ado\msado15.dll" produced a message that msado15.dll was loaded but the call to DllRegisterServer failed with the error code 0x80070005

     

    Not sure what to do next to solve why ASP does not run on Vista and IIS7

    ASP Classic classic asp ASP

  • Re: ASP db connection problem in IIS7

    Mar 28, 2009 06:21 PM|steve schofield|LINK

    Here is another thread that might be help.

    http://forums.iis.net/t/1066385.aspx

     

    Steve Schofield
    Windows Server MVP - IIS
    http://iislogs.com/steveschofield
    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget

  • Re: ASP db connection problem in IIS7

    Mar 31, 2009 09:49 AM|ddepuydt|LINK

    If you go to the advanced settings of your application pool (off course the app pool where your site is running in) and you set the "Enable 32-Bit Applications" to true, thing might start working. (There is no such thing as 64bit JET drivers).

    I assume you are running on a 64bit system?

  • Re: ASP db connection problem in IIS7

    Mar 31, 2009 10:31 AM|davidmills02|LINK

    Thank you for the suggestion - I am still on 32 bit system

    Regards

    David

  • Re: ASP db connection problem in IIS7

    Apr 21, 2009 04:41 PM|rlockard|LINK

    I am on a 64-bit system and updating this setting fixed the problem for me.

  • Re: ASP db connection problem in IIS7

    Aug 06, 2009 02:32 PM|youtea|LINK

    I'm running into the same problem also.

    I have a clean install of Vista x32 and IIS7. When classic asp tries to connect to my MSSQL server, I'm getting the same error.

    Do I have to install anything there? If Vista comes with Windows DAC 6.0, then why my connections are not working?

  • Re: ASP db connection problem in IIS7

    Aug 07, 2009 04:55 AM|davidmills02|LINK

  • Re: ASP db connection problem in IIS7

    Nov 14, 2009 10:33 AM|u1anderson|LINK

    Same problem here, getting:

    ADODB.Connection error '800a0e7a'

    Provider cannot be found. It may not be properly installed.

    Running Windows 7 Ultimate 64-bit IIS 7.5 

     

    Setting Enable 32-Bit Applications=True  in the Advanced Settings on the Application Pool solved it for me.

     

     

    - In Internet Information Services (IIS) Manager, select the IIS Server 

    - Actions -> View Application Pools

    - Select the application pool for your web site

    - Under Edit Application Pool, click Advanced Settings...

    - Set Enable 32-bit Applications to True (default is False)

     

    Works now!

     

     

     

  • Re: ASP db connection problem in IIS7

    Nov 14, 2009 03:20 PM|steve schofield|LINK

    Thanks for reporting how you resolved the issue.  It'll help others in the community.

    Steve Schofield
    Windows Server MVP - IIS
    http://iislogs.com/steveschofield
    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget

  • Re: ASP db connection problem in IIS7

    Aug 07, 2019 08:53 PM|NedStark|LINK

    In my case, the issue was the application itself. It wasn't compatible with Oracle 12c. The issue could also be one of these:

    1. In the Visual Studio, 32-bit Oracle DLL is referenced and the application is compiled with this DLL. If the application currently works, this is not the case. In order to double check,go to application folder and find the Oracle DLL (It should be in the bin folder). Check if it is 32-bit or 64-bit. If it is 32-bit, you can manually replace it with the 64-bit DLL or you can recompile the application by referencing 64-bit DLL
    2. The application is configured to use Oracle DLL that is installed in the server. The DLL installed is 32-bit. This scenario seems to be more accurate for this case. Even if you installed both 32-bit and 64-bit Oracle DLLs in the server, application might be still picking up the 32-bit in runtime. If this is the case, you can solve the issue by:
      • Copying 64-bit DLL to the bin folder in the application directory
      • Removing Oracle 32-bit DLL from the server if there is no other applications need it

    Source: Attempt to load Oracle client libraries threw BadImageFormatException