Oracle Provider Issue RRS feed

  • Question

  • Hi all,

    On the dev server, I'm using SSAS 2005 (32-bit) + Oracle provider for OLE DB to access my Oracle Database and it works perfectly.

    On the production server, SSAS 2005 is running on a  64-bit platform.  

    The Oracle client (64 bit) has been installed containing  the Oracle provider for OLE DB  but unfortunately the Oracle provider for OLE DB  does not appear in the list in BIDS when trying to create a date source.

    Could someone help ?



    Monday, August 21, 2006 8:55 AM


  • I remeber a similar problem. It just could be just a problem of showing provider in tools.

    Try authoring your connection on 32 machine and deploy it to 64bit machine. See if Analysis Server can connect to Oracle.
    If not try using .NET Oracle client.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, August 22, 2006 7:01 PM