May 21, 2009 at 6:45 am
I am converting a few SQL Server 2005 SSIS packages from Windows Server 2003 R2 Standard SP2 to 64 bit Windows Server 2003 R2 Enterprise SP2. The packages move a modest amount of data to an Oracle 10G database.
Anyone know where I can find a supported provider for 64 bit WinServ03? The Oracle provider 10.2.0.3 and ODAC is not for Windows Server 2003, but for a client (Windows XP).
Thank you for any help -
Alan
blogging at
May 21, 2009 at 10:19 am
I don't understand what you are saying because when your package works in x86 that is 32bits you can just copy it to x64 for deployment. And Oracle provider of 10g RC2 works with all Microsoft operating system with minor issues with Vista and Win2008 x64 because both don't use MDAC and no issues Win2003 x64 and XP. So check the first link below for known issue and the second link to download Win2003 x64 OLE DB driver. Microsoft partners also have free Oracle and Tera Data connectors for SSIS you can download, so I see only solutions and many options.
Kind regards,
Gift Peddie
May 26, 2009 at 12:28 pm
My problem is not moving the package between systems. The problem is installing an Oracle OLE DB provider (driver) which is useable from within BIDS on my 64-bit Windows 2003 Enterprise server.
I've downloaded and installed:
102010_win64_x64_database.zip
p68101189_10204_MSWIN-x64-64.zip - Oracle patch to version 10.2.0.4
ODAC10203x64 - access components
http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html
with little difficulty. We can use SQL-Plus to access our database. But when I open BIDS and try to add a connection to a simple Integration Services test package the Oracle providers (drivers) for OLE-DB are not visible. Same with the Oracle ODBC Driver Configuration; it lets me enter the server and account but will not connect. The Oracle "inventory" shows the OLE DB provider. But it is not visible. Is there some registry setting or Microsoft step that will make the provider visible?
How do I install an Oracle provider so it is useable from within BIDS?
Appreciate any help on this quest.
May 26, 2009 at 12:47 pm
BIDS which is VS2005 is a 32bits application so you need to install Oracle x86 driver because that is the only way to connect use SSIS to develop packages. That is the reason to develop the package in 32bits and deploy in x64 and it will run all the known issues are resolved. So to develop software with Oracle in Win2003 x64 you could use Oracle 32bits provider and build anycpu if you are in VS2005/8 Team Suites and DB Pro or use x86 if you are in BIDS because it comes without build options.
Kind regards,
Gift Peddie
May 26, 2009 at 2:18 pm
Ok, I sort of understand a little - but I am confused.
How do I install a 32-bit Oracle x86 provider (driver?) on a 64-bit server and set up connections correctly?
Does anyone know of any usable documentation which describes this?
I can't be the first person trying to connect a 64-bit Windows 2003 Enterprise server to an Oracle database, am I?
Thanks again - this is frustrating for a SQL Server developer.
May 26, 2009 at 2:41 pm
That is the reason I gave you the MSDN forum thread if you have read it you would have seen this link which shows you known issues and how to fix it.
http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply