Results 1 to 5 of 5

Thread: Oracle connector installation issues

  1. #1
    giriraghu is offline Junior Member
    Join Date
    Jul 2009
    Posts
    1
    Rep Power
    0

    Oracle connector installation issues

    Hi all,
    After installing the connector, when I try to configure the Oracle Source in BIDS, I get a nasty error message. The message is -
    "Error at Package [Connection Manager "Oracle connector 1"]: The ORACLE registry key cannot be opened. Verify that the oracle client for Windows x86 is installed properly.

    Please help me out.

    Thanks.

    Best regards,
    girish

  2. #2
    Yossi Shitrit is offline US Technical Team
    Join Date
    Sep 2006
    Posts
    38
    Rep Power
    0
    Hi Girish,

    Do you have Oracle client 32bit installed on the same machine as BIDS? Oracle client 32bit is required for design time.
    Are you running BIDS on a 32bit or 64bit machine?

    Thanks,
    Yossi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    aconcepcion is offline Junior Member
    Join Date
    Dec 2010
    Posts
    1
    Rep Power
    0
    Hi Yossi,

    I got the same problem. Im running on 64bit machine.

    Do I have to install the Oracle client 32bit and 64bit on machine?

    Thanks
    Aloy

  4. #4
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Aloy,

    Yes, you need to install the 32-bit Oracle client in order to be able to develop packages using BIDS (SQL Server Business Intelligence Development Studio), because BIDS runs in 32-bit mode.

    To run packages in x64 machine you will need the 64-bit Oracle client although you may run the package in 32-bit (non default mode) and in this case avoid installing the 64-bit client.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    Santosh is offline Junior Member
    Join Date
    Jul 2014
    Posts
    1
    Rep Power
    0

    Question

    Quote Originally Posted by Gadi.Farhat View Post
    Hi Aloy,

    Yes, you need to install the 32-bit Oracle client in order to be able to develop packages using BIDS (SQL Server Business Intelligence Development Studio), because BIDS runs in 32-bit mode.

    To run packages in x64 machine you will need the 64-bit Oracle client although you may run the package in 32-bit (non default mode) and in this case avoid installing the 64-bit client.


    Regards,

    Gadi
    Hi ,

    I have MS SQL server 2012 installed on a server and on D drive and the machine is 64 bit machine and the Oracle server is in some other Server.

    Now can i install both 32 bit and 64 bit Oracle client ? and where do i need set the path folder to ? (i.e) by default the path installation is showing as c:\Program files(*86)\.....
    so do i need to change the path to D drive ? . Please let me know this as i am in urgent need of the answer.

    Thanks ,
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •