Excel和Oracle类未注册的问题 [英] Excel and Oracle class not registered issue

问题描述

我正在创建在云服务器上运行的新SSIS作业。该作业从excel文件获取数据并加载到oracle db。我在服务器上安装了Microsoft ACE 2010 64位版本，并安装了oracle 12c 32和64位。如果我在32位dtexec中执行
任务，excel源会失败，但oracle会工作。如果我在64位dtexec中执行作业，excel可以工作，但oracle失败。在两种情况下，失败原因是"类未注册"。如果64位不存在，请尝试执行32位版本"。
请帮助修复此问题。

I am working on creating new SSIS job which runs in cloud server. The job gets data from excel file and loads to oracle db. I have Microsoft ACE 2010 64 bit version installed in the server and oracle 12c 32 and 64 bit installed as well. If I execute the task in 32 bit dtexec, excel source fails but oracle works. If I execute the job in 64 bit dtexec, excel works but oracle fails. In both scenarios the failure reason is "Class not registered. If 64 bit is not present please try executing in 32 bit version". Please help with fix for this issue.

推荐答案

您不能并排安装Oracle OleDB 32 + 64位都注册了。如果我提醒它，最后安装的提供商会被注册。最好是卸载ODAC并仅安装64位提供程序。

You can not have Oracle OleDB 32 + 64 bit installed side-by-side and both registered. If I remind it right the last installed Provider gets registered. The best is to uninstall ODAC and install only the 64 bit provider.

这篇关于Excel和Oracle类未注册的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！