Oracle Install for SSIS连接(和驱动程序32 64位) [英] Oracle Install for SSIS connectivity (and drivers 32 64 bit)

问题描述

我有一个SSIS包(SQL 2008)，需要使用它连接到Oracle DB(11g).我需要安装什么才能连接到oracle?什么用的?我完成的所有搜索都谈论Instant Client，但是下载后却看不到exe文件?我知道安装服务器会给我Oracle Net Manager(用于更新TNSNames.ora的UI)，但是我不想安装整个服务器.那太过分了.什么是最小的占用空间，以便我可以通过SSIS中的连接管理器创建到oracle数据库的连接?

I have an SSIS package (SQL 2008) that I need to connecto to an Oracle DB (11g) with. What do I need to install to connect to oracle? What's the terminology ? All searches I've done talk about Instant Client, but on downloading that I see no exe's? I know installing the server will give me that Oracle Net manager (UI to update TNSNames.ora) but I don't want to install the entire server. That to be is overkill. What's the smallest footprint so that I can create a connection to an oracle DB via my Connection Manager in SSIS?

即时客户端与& Oracle客户端工具等?有太多奥秘(对我而言至少)的术语令人困惑.

Also what's the difference between Instant Client & Oracle Client tools etc? There's so much arcane (atleast to me) terminology that it's confusing.

P.s. -通过阅读 http://www.oracle.com/technetwork/topics/dotnet/index-085163.html 您会以为这是我想要的，但是下载的文件中只有一个install.bat，似乎什么也没做！到目前为止，我尝试过的典型解决方案".

P.s. - From reading http://www.oracle.com/technetwork/topics/dotnet/index-085163.html you would think this was what I wanted, but the download just has an install.bat that seems to do nothing! Typical of the "solutions" I've tried so far.

推荐答案

好，我所做的是下载了适用于Microsoft Windows(x64)的Oracle Database 11g第2版客户端(11.2.0.1.0)来自 http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html .它有4个安装选项，其中一个是Instant Client(这对我没有帮助).可以使用的是运行时客户端或类似的名称.它会安装我想要的Net Manager.

Well, what I did was download Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html. It had 4 options for installing One of them being Instant Client(which did not help me). The one that works is Runtime client or something named like that. It installs Net Manager which is what I want.

PS-再加上(在我穿越Oracle 64位之旅时)，我发现无法将SSIS与64位oracle DB提供程序一起使用.我得到了异常(在SSIS中添加连接时):

PS-Adding on (as I traverse the Oracle 64 bit journey), I find that I cannot use SSIS with 64 bit oracle DB providers. I get the exceptions (on adding a connection in SSIS):

由于以下原因，测试连接失败 初始化提供程序时出错. 尝试加载Oracle客户端 图书馆扔 BadImageFormatException.这个问题 在64位模式下运行时将发生 使用32位Oracle客户端 组件已安装.

Test connection failed because of an error in initializing provider. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

我猜这是因为SSIS进程是32位的，并且不能使用64位的oracle驱动程序(我的主机是Win 7 64位).

I'm guessing this is because SSIS process is a 32 bit one and cannot use 64 bit oracle drivers (my host machine is Win 7 64 bit).

经过测试，我发现确实如此. 我们仅需要用于SSIS IDE的32位驱动程序，但是在使用64位dtexec.exe(C:\ Program Files \ Microsoft SQL Server \ 100 \ DTS \ Binn)

After testing, I found that this is indeed the case. We need the 32 bit drivers only for the SSIS IDE but can use 64 bit when running the DTSX package using the 64 bit dtexec.exe (C:\Program Files\Microsoft SQL Server\100\DTS\Binn)

因此，在DEVELOPMENT(在64位计算机上)上，安装32和64位客户端: 32位:用于在Visual Studio IDE中进行开发 64位:在命令行上使用dtexec.exe的64位版本运行DTSX包(就像在生产环境中运行DTSX包一样)

So in DEVELOPMENT (on a 64 bit machine) install both the 32 and 64 bit clients: 32 bit: for development in Visual Studio IDE 64 bit: To run the DTSX package using the 64 bit version of dtexec.exe on the command line (as would be the case when we run this in a production environment)

此处类似的线程..

A similar thread here.

这篇关于Oracle Install for SSIS连接(和驱动程序32 64位)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！