日期:2014-05-16  浏览次数:20887 次

SSIS connect Oracle
本人想通过SSIS 将数据导入到Oracle 的数据库中, 但用Oracle Provider for OLE DB 与 Microsoft OLE DB Provider for Oracle 都连接不上。会显示:
 Test connection failed because of an error in initalizing provider.The 'OraOLEDB.Oracle.1'provider is not registered on the local machine.或: Test connection failed because of an error in initializing provider.Oracle client and networking component were not found.these components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
但是我的版本是Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
 Prod PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0  
 Production TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
PL/SQL 没问题能连接上,使用OLE DBDestionation 时也使用的节点名,有的还说是因为注册表的问题,但我也不知道如何查看,请问如何解决?在线等结果!

------解决方案--------------------
貌似对应的驱动版本过低

these components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.