none
error while acessing access db on 64bit windows server RRS feed

  • Question

  • Hello experts,

     

    I have a old system developed in .NET 2.0 accessing access database. i need to deploy the same on IIS of windows server 2003 64 bit.

     

    I get a error "Exception Details: System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

    strange part is when i run the website from visual studio 2005 on the same server it works fine.

     

    any idea of the error or some solution for the same.

     

    /chandresh soni

    Wednesday, September 17, 2008 9:35 AM

All replies

  • Not sure if I'm following the scenario here but it sounds like the app is running in the 64-bit world and it cannot open the Access database because there is no 64-bit driver support.

     

    I believe that there is a configuration setting for IIS that will enable your ASP.NET app to run as a 32-bit process.

     

    Wednesday, September 17, 2008 3:50 PM
  • it's better to use the new Microsoft Access Database Engine 2010, since there's no 64-bit driver support for Jet.OLEDB.4.0.

    All you have to do is changing the connection string from "Provider=Microsoft.Jet.OLEDB.4.0; "  to  "Provider=Microsoft.ACE.OLEDB.12.0;".
    Microsoft Access Database Engine 2010 has a 32 and 64 bit versions : http://www.microsoft.com/download/en/details.aspx?id=13255

    but if you want to force the Jet OLEDB 4.0 to run on a 64 bit environment here's what to do (it's for IIS7) : http://www.codicode.com/art/the_microsoft_jet_oledb_4_0_prov.aspx

    hope this helps.

    Tuesday, March 13, 2012 3:57 PM