«
»

Using JET OLE DB under ASP and Vista x64

I’m currently performing some work on classic ASP pages that during development are retrieving data from an existing Microsoft Access database. After receiving the following error I found that Microsoft haven’t and have no plans to release JET OLE DB drivers for 64-bit platforms. Fair enough it’s hardly the way of the future but I wanted to be able to perform some development on the pages before migrating to SQL/Server.

Provider=Microsoft.Jet.OLEDB.4.0
ADODB.Connection error ‘800a0e7a’
Provider cannot be found. It may not be properly installed.

After some digging around I found the solution was to change the IIS 7 settings to run the application in 32-bit mode. That can be performed under Vista x64 using the following steps:

  • Click Start > All programs > Administrative tools > Internet Information Server (IIS) Manager
  • Under the machine name click on Application Pools.
  • Right-mouse click on DefaultAppPool and select Advanced Settings…
  • Under the general section set “Enable 32-Bit Applications” to true.
  • Press OK and IIS should now be running in 32-bit mode, no other actions are necessary.

    This entry was posted on Sunday, November 1st, 2009 at 10:02 am and is filed under Programming, SQL / Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

    • One Response to “Using JET OLE DB under ASP and Vista x64”

    1. FREDRICK says:
      June 30, 2010 at 3:12 pm


      Pillspot.org. Canadian Health&Care.No prescription online pharmacy.Best quality drugs.Special Internet Prices. Low price drugs. Buy pills online…

      Buy:Benicar.Lipitor.Zocor.Ventolin.Advair.Zetia.Wellbutrin SR.Prozac.Seroquel.Nymphomax.Lasix.Cozaar.Lipothin.Amoxicillin.Female Cialis.Buspar.Aricept.SleepWell.Acomplia.Female Pink Viagra….

    Leave a Reply