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?
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：
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.
uick383937
Member
81 Points
117 Posts
Access DBs under VisStudio 2012 and IIS8 on Win8 PC
Nov 24, 2012 08:36 PM|LINK
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
oned_gk
All-Star
31375 Points
6413 Posts
Re: Access DBs under VisStudio 2012 and IIS8 on Win8 PC
Nov 25, 2012 03:37 AM|LINK
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Access DBs under VisStudio 2012 and IIS8 on Win8 PC
Nov 25, 2012 08:20 AM|LINK
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/
uick383937
Member
81 Points
117 Posts
Re: Access DBs under VisStudio 2012 and IIS8 on Win8 PC
Nov 28, 2012 05:55 PM|LINK
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.