Can't get Oracle OLE DB provider to work from SSIS on a 64-bit environment
- From: "Steen Schlüter Persson (DK)" <steen@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 09:38:39 +0200
Hi
I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more.
I'm having some troubles setting up an Oracle datasource on a SSIS
installation running 64-bit. We have it setup in our test/dev
environment running 32-bit where it works with Microsoft OLEdb Provider
for Oracle. Since this Provider isn't available in the 64-bit version I
was told to install the Oracle OLE DB provider client.
I did that and from Management Studio on that server, I can set up a
linked server using this provider and that works fine. When I then in
SSIS set up a connection using this Oracle OLE db provider and
specifying the same servername, I get an error when I test the
connection. The error is :
Test connection failed because of an error in initializing provider.
ORA-12154: TNS: kunne ikke fortolke den angivne
forbindelsesidentifikator (The last bit is in Danish and translated it
says something like 'Couldn't understand the actual connection
indicator').
If I look a the providers that are being used, I can see that the linked
server is using a provider called 'OraOLEDB.Oracle' where in SSIS it's
using a provider called 'OraOLEDB.Oracle.1'. This is most likely
because I first installed the regular Oracle client and then later on
when I figured out that I need the Oracle ODAC I installed that. I then
ended up with 2 Oracle "client" installations, so that is most likely
why I see 2 different providers. What then puzzles me, is how I can
choose which one to use. No matter what I do, it seems like the .1 is
chosen in SSIS. I've even tried to uninstall the "old" client but that
doesn't make any difference.
I'd love to uninstall both Oracle clients and then try just to install
the ODAC, but that isn't that simple. First of all, there are no way to
uninstall ODAC and when I uninstall the regular Oracle Client with the
installer, it still leaves a lot of files and registry entires around..:-(.
I've set up Oracle connections many times and feel I'm having a fair
grip of how it should be done, but this 64-bit /SSIS issue is driving me
nuts.....
Does any of you have any good suggestions on how to solve this issue?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
.
- Follow-Ups:
- Re: Can't get Oracle OLE DB provider to work from SSIS on a 64-bit environment
- From: Russell Fields
- Re: Can't get Oracle OLE DB provider to work from SSIS on a 64-bit environment
- Prev by Date: RE: SSIS FTP Task
- Next by Date: Re: DTS - ActiveXScripting Not Working on 64bit AMD Cluster on SQL Server 2005 SP2
- Previous by thread: RE: SSIS FTP Task
- Next by thread: Re: Can't get Oracle OLE DB provider to work from SSIS on a 64-bit environment
- Index(es):
Relevant Pages
|
