« Previous Next »

• 08-22-2008, 4:23 PM

  AmitBu Joined on 08-22-2008, 7:53 PM Posts 3

  ASP db connection problem in IIS7 Reply Contact 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!

  Tags: vista db connection problemdb connection problem in IIS7

• 08-22-2008, 6:46 PM

  In reply to

  mukhtard Joined on 07-07-2008, 9:13 PM Redmond, WA Posts 202	Re: ASP db connection problem in IIS7 Reply Contact Do you have MDAC installed? Thanks, Mukhtar Desai IIS Performance Team

• 08-22-2008, 7:20 PM

  In reply to

  AmitBu Joined on 08-22-2008, 7:53 PM Posts 3	Re: ASP db connection problem in IIS7 Reply Contact 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...

• 08-22-2008, 7:40 PM

  In reply to

  mukhtard Joined on 07-07-2008, 9:13 PM Redmond, WA Posts 202	Re: ASP db connection problem in IIS7 Reply Contact 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

• 08-22-2008, 7:46 PM

  In reply to

  AmitBu Joined on 08-22-2008, 7:53 PM Posts 3	Re: ASP db connection problem in IIS7 Reply Contact  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 :)

• 08-22-2008, 9:42 PM

  In reply to

  mukhtard Joined on 07-07-2008, 9:13 PM Redmond, WA Posts 202

  Re: ASP db connection problem in IIS7 Reply Contact 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

• 09-16-2008, 1:44 PM

  In reply to

  Kanien Joined on 01-31-2008, 12:14 AM Posts 104	Re: ASP db connection problem in IIS7 Reply Contact  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

• 03-28-2009, 3:56 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: ASP db connection problem in IIS7 Reply Contact 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

  Tags: ASP Classicclassic aspASP

• 03-28-2009, 6:21 PM

  In reply to

  steve schofield Joined on 06-10-2002, 4:54 PM MI Posts 3,935	Re: ASP db connection problem in IIS7 Reply Contact Here is another thread that might be help. http://forums.iis.net/t/1066385.aspx   Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget

• 03-31-2009, 9:49 AM

  In reply to

  ddepuydt Joined on 10-06-2002, 3:25 PM Posts 6	Re: ASP db connection problem in IIS7 Reply Contact 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?

• 03-31-2009, 10:31 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27	Re: ASP db connection problem in IIS7 Reply Contact Thank you for the suggestion - I am still on 32 bit system Regards David

• 04-21-2009, 4:41 PM

  In reply to

  rlockard Joined on 04-21-2009, 2:36 AM Posts 1	Re: ASP db connection problem in IIS7 Reply Contact I am on a 64-bit system and updating this setting fixed the problem for me.

• 08-06-2009, 2:32 PM

  In reply to

  youtea Joined on 08-06-2009, 6:29 PM Posts 1	Re: ASP db connection problem in IIS7 Reply Contact 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?

• 08-07-2009, 4:55 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27	Re: ASP db connection problem in IIS7 Reply Contact try this link http://forums.iis.net/t/1156401.aspx?PageIndex=2

• 11-14-2009, 10:33 AM

  In reply to

  u1anderson Joined on 11-14-2009, 3:27 PM Posts 1

  Re: ASP db connection problem in IIS7 Reply Contact 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!