Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS - Oracle Client

Posted on 2013-06-16
4
Medium Priority
?
760 Views
Last Modified: 2016-02-11
I'm trying to set up a server with SSIS to connect to Oracle.
The server is windows server 2008 R2; SSIS is VS 2010.

I downloaded the instant client (64 bit) and put it in a directory.  I then set the environmental variables to both the oracle_home and tns_admin (for tnsnames.ora).

Now when I attempt to make an oracle connection in SSIS, I get the following error.

 error.jpg
0
Comment
Question by:patriotpacer
  • 2
  • 2
4 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39251978
What data access provider are you using?

Unless it is the JDBC-Thin connection, I don't think just the Instant Client is enough.

There are additional packages, like ODBC that are available.

I've also seen posts that mention you also need the 32Bit Instant Client but I've never used SSIS or SQL Server so cannot say for sure.
0
 

Author Comment

by:patriotpacer
ID: 39253423
It does have to do with SSIS running 32 bit.

The guidance I'm seeing is to install both the 32 bit and 64 bit.  

I have the 64 bit installed now and all seems fine when I tested an ODBC connection.

But if i also install the 32 bit client what do I set the oracle_home and tns_admin variables to?
0
 

Author Closing Comment

by:patriotpacer
ID: 39253430
Just got it to work!  You were right on the 32 bit thing.

What I did to finish off was to install the 32 bit ODAC install and set the environment variables to the new 32 bit version.

I guess you may need the 64 bit if you want to do an ODBC connection?
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39253973
>>I guess you may need the 64 bit if you want to do an ODBC connection?

ODBC doesn't care about 64 or 32 bit.  It's the apps that access the drivers.  64Bit apps, need 64Bit drivers, 32Bit apps need 32Bit drivers.

From what I read about VS and SSIS is that they mix pieces of the apps.  Some of it is 64Bit and some of it is 32Bit.

Google it.  That's how I came across it but most of it I didn't understand since I'm not a MSoft person.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A safe way to clean winsxs folder from your windows server 2008 R2 editions
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This video shows how to recover a database from a user managed backup
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question