locked
ASP db connection problem in IIS7 RRS feed

  • Question

  • User1647136275 posted
    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!
     
    Friday, August 22, 2008 4:23 PM

All replies

  • User844605415 posted

    Do you have MDAC installed?

    Thanks,
    Mukhtar Desai
    IIS Performance Team

    Friday, August 22, 2008 6:46 PM
  • User1647136275 posted

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

    Friday, August 22, 2008 7:20 PM
  • User844605415 posted

    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

    Friday, August 22, 2008 7:40 PM
  • User1647136275 posted

     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 :)

    Friday, August 22, 2008 7:46 PM
  • User844605415 posted

    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

    Friday, August 22, 2008 9:42 PM
  • User-1727019647 posted

     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

     

    Tuesday, September 16, 2008 1:44 PM
  • User86331157 posted

    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<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
    Saturday, March 28, 2009 3:56 AM
  • User1073881637 posted

    Here is another thread that might be help.

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

     

    Saturday, March 28, 2009 6:21 PM
  • User1366430319 posted

    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?

    Tuesday, March 31, 2009 9:49 AM
  • User86331157 posted

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

    Regards

    David

    Tuesday, March 31, 2009 10:31 AM
  • User1045574487 posted

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

    Tuesday, April 21, 2009 4:41 PM
  • User612463852 posted

    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?

    Thursday, August 6, 2009 2:32 PM
  • User86331157 posted

    try this link http://forums.iis.net/t/1156401.aspx?PageIndex=2

    Friday, August 7, 2009 4:55 AM
  • User-788610757 posted

    Same problem here, getting:

    <!-- Main body -->

    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!

     

     

     

    Saturday, November 14, 2009 10:33 AM
  • User1073881637 posted

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

    Saturday, November 14, 2009 3:20 PM