SSIS连接Oracle报错ThesecomponentsaresuppliedbyOracle
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了SSIS连接Oracle报错ThesecomponentsaresuppliedbyOracle,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2258字,纯文字阅读大概需要4分钟。
内容图文
![SSIS连接Oracle报错ThesecomponentsaresuppliedbyOracle](/upload/InfoBanner/zyjiaocheng/532/ddf2211ff6d643aab7632cd0a2034c44.jpg)
早上有个朋友发邮件给遇到一个SSIS连接Oracle的问题,具体的错误信息如下: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Cor
早上有个朋友发邮件给遇到一个SSIS连接Oracle的问题,具体的错误信息如下:
Test connection failed because of an error in initializing provider. Oracle client and networking components 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.
Provider is unable to function until these components are installed.
问题的原因:
1.因为BIDS是32位的应用程序即使在64位的机器上面,所以无法使用64位的Microsoft Provider for Oracle.所以从64位的机器上连接Oracle无法成功。
2.因为Microsoft Provider for Oracle只提供了32位的版本,而且微软没有计划在将来发布64的版本。
3.Oracle客户端自身问题,需要安装完整11G客户端。
解决办法如下:
-
Download the Oracle 11G full client.
-
Install the 32 AND the 64 bit version of the 11G full client (Installation Type: Administrator) and reboot the server afterwards. The 32 bit version is needed for development from BIDS with is 32 bit, the 64 bit version is needed for production with the SQLAgent, which is 64 bit.
-
Configure the Oracle clients (both 32 and 64 bits) by editing the files tnsnames.ora and sqlnet.ora. Try to do this with an Oracle DBA or, even better, let him/her do this.
-
Use the "Oracle provider for OLE DB" from SSIS, don't use the "Microsoft Provider for Oracle" because a 64 bit version of it does not exist.
-
Schedule your packages with the SQLAgent.
对于SQL Server 2008 R2的机器需要做额外配置:
1. Open REGEDIT (Start… Run… REGEDIT) on the server and search for the following entry (for the 32 bits driver):
HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC\MTxOCI
Make sure the following values are entered:
2. Next, search for (for the 64 bits driver):
HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\MSDTC\MTxOCI
Make sure the same values as above are entered.
3. Reboot your server.
来源于:http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx
内容总结
以上是互联网集市为您收集整理的SSIS连接Oracle报错ThesecomponentsaresuppliedbyOracle全部内容,希望文章能够帮你解决SSIS连接Oracle报错ThesecomponentsaresuppliedbyOracle所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。