关于异常“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”的处理
来源:互联网 发布:淘宝客服的奖金制度 编辑:程序博客网 时间:2024/05/17 05:50
我们在利用SqlBlukcopy技术倒2010 或者2007格式的文件到SqlServer 数据库的时候,会发生如下错误:
原因如下:
1.在用SQL SERVER 2005访问.xlsx文件(office2007&2010文件格式)时,必须用
provider 'Microsoft.ACE.OLEDB.12.0' 来实现。
2.首先要安装AccessDatabaseEngine.exe。
下载路径:http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
3.在32位系统中可以在数据库中看见这个provider。
4.在64位系统中不能看见它,这时需调用
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe
来执行package。
解决方案:
1、打开IIS管理器
2、右击应用程序所在的连接池
3、修改“启用32为应用程序”为true
0 0
- 关于异常“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”的处理
- 关于异常“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”的处理
- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local Machine 完美解决
- The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine (zz)
- The 'Microsoft.ACE.Oledb.12.0' provider is not registered on the local machine
- Solution: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
- Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine erro
- 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
- HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"
- 包执行中提示错误:The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
- 导入xlsx文件提示:The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
- Excel导入数据库错误:The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine
- The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine (zz)
- The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine 解决办法
- The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
- The 'Microsoft.Jet.OleDb.4.0' provider is not registered on the local machine
- The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
- The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
- 143. Reorder List
- 练习二 1005 汽车转弯问题
- 嵌入式学习笔记(一)
- 安装genymotion时遇到的问题
- JavaEE编程技术(JSP/Servlet)
- 关于异常“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”的处理
- 获取手机是否开启GPS
- JSP 中设置公共模块的方法
- 树的子结构
- 信息系统项目管理师
- HDU2602_01背包问题
- 1042. Shuffling Machine (20)
- 错误:the public type XXX must be defined in its own file.
- IOS图片转base64字符串和字符串转回图片