How to fix "OLE DB provider is not registered"
来源:互联网 发布:windows刷新英文 编辑:程序博客网 时间:2024/06/06 16:42
SSIS从Excel2007(xlsx)文件中抽取数据保存到数据库,提示以下错误:
Error 1 Validation error. Data Flow Task: Package: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Package.dtsx 0 0
在把文件保存成为Excel2003(xls)后,可以读取。
初步怀疑是驱动问题。
首先是去下载一个Access Database Engine.
到这一步大多数人已经可以正常使用了。
如果还不行,那么再下载另一个驱动,2007 Office System Driver: Data Connectivity Components
其他备选方案:
1.在项目属性当中,把Run64BitRuntime设置为False.
2.在Connection Manager当中,设置DelayValidation属性为True.
0 0
- How to fix "OLE DB provider is not registered"
- HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"
- How to fix "'user' is not in sudoers" in CentOS
- How to Fix :NameError: name 'reload' is not defined
- The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider i
- "Firefox is already running but is not responding" error message - How to fix it
- the vfpoledb provider is not registered on the local machine
- Microsoft.ACE.OLEDB.12.0 provider is not registered (zz)
- Microsoft.ACE.OLEDB.12.0 provider is not registered解决方案
- The operation could not be performedbecause OLE DB provider "SQLNCLI" for linked serve
- A rowset based on the SQL command was not returned by the OLE DB provider
- uri is not registered
- URI Is Not Registered
- uri is not registered
- URI is NOT Registered
- URI Is Not Registered
- Error message: OLE DB provider SQLOLEDB was unable to begin a distributed transaction
- OLE DB provider "SQLNCLI11" for linked server "dbLink01" was unable to begin a distributed transac
- 很认真的聊一聊:坚持一个程序员的自我修养
- Android 反编译lib库和源文件
- ceoi2011 切题记
- SpringMVC学习笔记1:springMVC1 springmvc的基础知识
- ios监测相册变化
- How to fix "OLE DB provider is not registered"
- Activity/Fragment 状态缓存和恢复的最佳实践
- 安卓实时弹幕demo(四)科大讯飞语音SDK
- PHP寻找子栏目
- 16. 3Sum Closest
- Mysql学习系列
- BFS广度优先遍历
- 剑指Offer:二进制中1的个数
- Oracle PL/SQL显示游标、隐式游标、游标循环