About the exception "the ' microsoft.ace.oledb.12.0 ' provider is not a registered on the local machine" treatment

When we use sqlblukcopy technology to pour 2010 or 2007 of files into the SQL Server database, the following error occurs:

The reasons are as follows:

1. When accessing an. xlsx file (office2007&2010 file format) with SQL SERVER 2005, you must use the
Provider ' microsoft.ace.oledb.12.0 ' to achieve.
2. Install AccessDatabaseEngine.exe first.
Download Path:http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891& displaylang=en
3. In a 32-bit system, you can see this provider in the database.
4. You cannot see it in a 64-bit system, you need to call
C:\Program Files (x86) \microsoft SQL Server\100\dts\binn\dtexec.exe
To execute the package.

Solution:

1. Open IIS Manager

2. Right-click the connection pool where the application resides

3. Modify "Enable 32 for application" to True

' microsoft.ace.oledb.12.0 ' provider is not registered on the local machine echnical Riviera Thumb "alt=" about abnormal echnical 淭 he ' microsoft.ace.oledb.12.0 ' p Rovider isn't registered on the local machine echnical Riviera thumb "src=" http://s9.sinaimg.cn/middle/64008ed7gb377f5371098&690 ">

Copy of the others, help solve the problem, the original address

About the exception "the ' microsoft.ace.oledb.12.0 ' provider is not a registered on the local machine" treatment