Home Forums SQL Server 2008 Working with Oracle OraOLEDB.Oracle.1 is not registered on the local machine RE: OraOLEDB.Oracle.1 is not registered on the local machine

  • August 16, 2012 at 1:01 am

    #1526349

    Welsh Corgi (8/15/2012)

    I need to configure Developers PC's.

    If I install the Oracle Client do I only need the 32 Bit Client?

    Thanks.

    It depends on the software that communicates with the Oracle database. 32 bit software requires 32 bit Oracle client and 64 bit software requires 64 bit Oracle client.

    Once I had to install both on SQL Server 2008 (R2). BIDS is 32 bit and required 32 bit Oracle client. The SQL Server Agent executing the package is 64 bit and required 64 bit Oracle client.