数据库|mysql教程
SSIS,连接,Oracle,报错,These,compon
数据库-mysql教程
发送邮件php源码下载,ubuntu键盘灯驱动,tomcat端口号映射,起点爬虫被封,php技术导向网站教程,seo 省钱技巧lzw
早上有个朋友发邮件给遇到一个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
游戏服务端源码,vscode离线安装点击安装,ubuntu 无权限,tomcat调用链,sqlite 创建 日期,网页设计定义字体的标记是,手机网页服务器,h5手机语音上传插件,简便前端框架,爬虫超越授权,装修php,网页seo优化推广,内网邮件 springboot,前端静态网站模板下载,网页文字打印特效,网贷表格模板,aspcms 重置后台密码,js页面显示 聊天室,java音乐管理系统源码,摄影测量后方交会程序lzw
手机编辑源码,vscode如何导入外部包,ubuntu配置有线,tomcat未启动不了,爬虫宠物养殖,php 写入数据库 乱码,深圳seo推广多少钱,网站文档,ecshop模板数据库配置文件lzw
早上有个朋友发邮件给遇到一个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 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.
来源于:/blogs/jorg_klein/archive//06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx