The Microsoft. Ace. oledb.12.0 provider is not registered on the local computer.

Source: Internet
Author: User
Tags microsoft access database

Microsoft. Ace. oledb.12.0 is not registered on the Local ComputerProgram.

Note:An error occurred while executing the current Web request. Check the stack trace information to learn about this error andCodeDetailed information about the cause of the error.

Exception details:System. invalidoperationexception: the Microsoft. Ace. oledb.12.0 provider is not registered on the local computer.

 

Download the 2007 Office System DRIVER: Install the data connection component

Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

This download installs a group of components that non-Microsoft Office applications can use to read data from the 2007 Office System File, such as from Microsoft Office Access 2007 (MDB and accdb) and Microsoft Office Excel 2007 (xls, XLSX, and xlsb) files. These components also support connecting to Microsoft Windows SharePoint Services and text files.

In addition, ODBC and oledb drivers are installed, which can be used by application developers to develop applications connected to office file formats.

Certificate --------------------------------------------------------------------------------------------------------------------------------------------------- Use this download: If you are an application user, see the application documentation for details about how to use the appropriate driver. If you are an application developer using oledb, set the provider parameter of the connectionstring attribute to "Microsoft. ace. oledb.12.0 "to connect to Microsoft Office Excel Data, add" Excel 12.0 "to the extended properties of the oledb connection string. If you are an application developer who uses ODBC to connect to Microsoft Office access data, set the connection string to "driver = {Microsoft Access Driver (*. mdb ,*. accdb)}; DBQ = path to MDB/accdb file "if you are an application developer who uses ODBC to connect to Microsoft Office Excel data, set the connection string to "driver = {Microsoft Excel Driver (*. xls ,*. XLSX ,*. xlsm ,*. xlsb)}; DBQ = path to XLS/XLSX/xlsm/xlsb file "details: accessdatabaseengine 2007 Office System DRIVER: data connection componentHttp://www.microsoft.com/downloads/zh-cn/details.aspx? Displaylang = ZH-CN & familyid = 7554f536-8c28-4598-9b72-ef94e038c891 Microsoft Access database engine 2010 redistributablehttp: // www.microsoft.com/downloads/zh-cn/details.aspx? Familyid = c06b8369-60dd-4b64-a44b-84b371ede16d
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.