none
Attunity 1.2 Data Connector for Oracle Error (Failed to load OCI method) RRS feed

  • Question

  • System Configuration: 32 bit Windows 7 machine

    Server: SQL Server 2008 R2

    Background: I am trying to use the Attunity data connector with SQL Server 2008 R2 to import data from Oracle to SQL database.  Using the out of the box MS SQL Server 2008 R2 Oracle oledb data connector doesn't work for our situation as it doesn't import correctly unicode characters.  This is why we had to move to a new data connector.  Using the Oracle provided connector we were able to get the package to work, but the MS Engineer recommended the Attunity Data Connector because it has better performance.

    Working solution, but not desired: Oracle 11g data connector.  (This has me to believe the Oracle_Home is setup correctly).

    Error:

    Attunity Error

    Possible solution: http://forums.attunity.com/forums/microsoft-ssis-oracle-connector/error-failed-load-oci-dll-1308.html

    I found the above link from the Attunity forum, but was unsure what to do for my situation as mine is 32 bit and the link primarily relates to 64 bit.  As I mentioned above I believe the Oracle_Home directory is setup correctly as I am able to connect and run an SSIS package with the same configuration using a different provider.  Also because of this fact of being able to run it with a different provider, I would assume permissions are configured correctly.  I believe it to be a configuration issue with possibly the registry, but I'm not sure where to look.

    Failed solutions: Uninstalling and reinstalled Attunity 1.2 connector.

    Thanks for you help in advance,

    Paul

    Friday, May 27, 2016 5:48 PM

All replies