|
Error message: "Microsoft. ACE.oledb.12.0" provider.Solution: Gohttp://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exeDownload. Then install it. This error is due to you using a database created by ACCESS2007 version, butserverThere is no program that works together, so there is an error. The "Microsoft. ACE.oledb.12.0" provider. Note:An unhandled exception occurred during the execution of the current web request. Check the stack trace information for details about the error and where it came from in your code that caused the error.
Exception details:System.InvalidOperationException: 未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序。
Download the 2007 Office system driver: Data Connection Component installation http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe This download installs a set of components that non-Microsoft Office applications can use to read data from 2007 Office system files,
For example, reading data from Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files.
These components also support establishing connections with Microsoft Windows SharePoint Services and text files.
In addition, ODBC and OLEDB drivers are installed for application developers to use when developing applications that connect with Office file formats.
---------------------------------------------------------------------------------------------------------------------------------------------------
Use this download:
If you are an application user, consult the application documentation for detailed information on how to use the appropriate driver.
If you are an application developer using OLEDB, set the Provider parameter of the ConnectionString property to "Microsoft.ACE.OLEDB.12.0"
If you want to connect to Microsoft Office Excel data, add "Excel 12.0" to the extended properties of the OLEDB connection string.
If you're an application developer using ODBC to connect to Microsoft Office Access data,
Please set the connection string to "Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=path to mdb/accdb file”
If you're an application developer using ODBC to connect to Microsoft Office Excel data,
Please set the connection string to "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=path to xls/xlsx/xlsm/xlsb file”
Details:http://www.microsoft.com/downloads/zh-cn/details.aspx?displaylang=zh-cn&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891
Or:
Solution 1 (Verification is OK)
Select the app's App pool ------> select Advanced settings ---------> enable 32-bit apps -------> true
Solution 2
Microsoft.ACE.OLEDB.12.0 can no longer be used on x64, you need to force your web application to compile to x86 and then publish it to Win08 x64, remember to set Enable 32bit Application = true on the application pool.
(No verification)
| 
Posted on 9/23/2015 9:34:30 AM
|
|
|
