Access DBs under VisStudio 2012 and IIS8 on Win8 PC

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

Answer 1

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

Answer 2

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/

Answer 3

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.