We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

ASP db connection problem in IIS7RSS

15 replies

Last post Nov 14, 2009 03:20 PM by steve schofield

  • 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