Powerpivot and Visual Studio BIMS on a x64 Windows7 connection problem to Oracle DB

Question

Hi,

is it possible to have Piwerpivot and BIMS running on the same x64 Windows 7.

In Powerpivot connecting to the Oracle Db works perfect.

In Visual Studio i get a BadImageFormatException. I think VS only works with x32 Oracle Client?

As far as I know Powerpivot (x64) only supports x64 Oracle Client and Visual Studio with a tabular project only? works with x32 Oracle Client.

Is there a way to get BIMS in Visual Studio running without crashing the Powerpivot because of installing x32 oracle Client?

 Regrads,

Steirer

Answer 1

As a solution i installed ODAC from oracle
http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html

i'm using Oracle Provider for OLE DB to connect to the DB.

Regards,

Steirer