locked
Access DBs under VisStudio 2012 and IIS8 on Win8 PC RRS feed

  • Question

  • User482458310 posted

    After porting localhost website which contains Access Databases to new Win 8 PC, I am getting error The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.  The local machine (64  bit) has IIS 8 as the web server.  Is there a way to fix this?

    Also, using Visual Studio Express 2012 I create a new test website.  When I try to add new item under App_Data the only DB choices are SQL Server DB and SQL Server Compact 4.0 Local Database.  Is support for Access Databases available?

    Thanks

    Saturday, November 24, 2012 4:36 PM

Answers

  • User482458310 posted

    I had installed Access 2000, and you are right, the .Jet provider was there.  Problem was that the error message is erroneous.  The fix was to enable 32 bit applications in IIS8.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 28, 2012 1:55 PM

All replies

  • User-1716253493 posted
    weblogs.asp.net/kencox/archive/2010/05/20/asp-net-iis-fix-the-microsoft-jet-oledb-4-0-provider-is-not-registered-on-the-local-machine.aspx
    Saturday, November 24, 2012 11:37 PM
  • User3866881 posted

    uick383937

    What kind of Access are you using?If you are using Access2003 or below,please install them and you will have such a driver;but if you are using Access2007 or above,you can have a connection string like this:

    http://www.connectionstrings.com/

    Sunday, November 25, 2012 4:20 AM
  • User482458310 posted

    I had installed Access 2000, and you are right, the .Jet provider was there.  Problem was that the error message is erroneous.  The fix was to enable 32 bit applications in IIS8.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 28, 2012 1:55 PM