Oracle Provider Issue

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 10.2.0.1.0 (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 ?

Regards,

Jean-Luc

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.

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