Microsoft is not registered on the local computer. ace.oledb.12.0 "Provider Solution

Source: Internet
Author: User
Tags odbc ole stack trace

Error message: Microsoft is not registered on the local computer. ace.oledb.12.0 "provider.

Solution:

Go to Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe to download. And then the installation will do.

This error is due to the fact that you have used the database created by the ACCESS2007 version, but there is no matching program in the server, so there is an error.

Microsoft is not registered on the local computer. ace.oledb.12.0 "provider.

  Note: An unhandled exception occurred during the execution of the current WEB request. Check the stack trace for more information about the error and where the error occurred in the code.

  Exception Details: System.InvalidOperationException: Microsoft is not registered on the local computer. ace.oledb.12.0 "provider.

Download 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 the 2007 Office system file, such as from Microsoft Office Access 2007 (MDB and accdb) files, and Mi Read data in Crosoft 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 OLE DB drivers are installed for application developers to use when developing applications that are connected to Office file formats. --------------------------------------------------------------------------------------------------------------- ------------------------------------ Use this download: If you are an application user, consult the application documentation for more information about how to use the appropriate driver. If you are an application developer who uses OLE DB, 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 OLE DB connection string. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the connection string to Driver={microsoft Access Driver (*.mdb, *.accdb)};D Bq=pat H 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)};D bq=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:

Workaround 1 (Verification available)

Select the application pool for the application------> select Advanced Settings---------> Enable 32-bit applications------->true

Solution 2

Microsoft.ace.oledb.12.0 can not be used x64, you have to force your Web application compiled into x86 and then released to Win08 x64, remember to set up on the application pool enable 32bit Application = True.

(No validation)

  Locomotive 8.3/8.4 version prompt error: microsoft.ace.oledb.12.0 provider workaround not registered on the local computer
The fox was upgraded from 8.3 to 8.4. The system has always been a win8.1,64 bit. This error occurs after the upgrade, and the solution is to download the Access driver

Properties-Compatibility-win7, finish after installation!

If not, refer to the following

This is due to the release of the 64-bit program in the 8.3/8.4 version, but access driven on the 64-bit system by default is not installed, you need to download a component installation.

Download Access driver: Data Connection Component Installation

Http://pan.baidu.com/s/1feun0

Direct installation may prompt

At this point, use the following method to install

1, use the "/passive" command to install, such as "C:directory Pathaccessdatabaseengine_x64.exe"/passive

2, after the installation is completed, view the registry hkey_local_machinesoftwaremicrosoftoffice14.0commonfilespaths, delete Mso.dll

3, if the above 2 point operation does not understand, please see http://faq.locoy.com/q-1107.html description

Reference http://blog.csdn.net/sundacheng1989/article/details/17925431

Other friends use the following methods, it is also feasible, users can choose their own

Environment:

System: WIN7 64-bit +office 2007 32-bit

Accessdatabaseengine Version: 2010 64-bit

Tools to use:

1.7zip Decompression Software

Download Address http://www.bitsCN.com/softs/11278.html

2, ORCA. Msi

Download Address: http://www.bitsCN.com/article/9476.htm

Operation Steps:

1, with 7ZIP open accessdatabaseengine, and then extract extracted to a folder, extracted files for aceredist.msi installation files and a CAB file.

2, with Orca open Aceredist.msi, find launchcondition inside Blockinstallation, delete, save. Then close exit Orca and run Aceredist.msi to install successfully.

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.