I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when
I try to deploy the cube on my SSAS 2008 server, it fails with the following error:
Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running
in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).
Errors in the high-level relational engine. A connection could not be made
to the data source with the DataSourceID of ', Name of '.
Errors in the OLAP storage engine: An error occurred while the dimension,