Problem creating Oracle Data Sources in SSAS 2008 R2

• Michael.Gagne

  SSC-Addicted

  Points: 442

  More actions

  August 18, 2011 at 12:17 pm

  #246456

  Working on a Windows 2008 server (64 bit), SQL 2008 R2 (64 bit) and I've installed Oracle 11g (64 bit).

  My data source is an Oracle 10g database.

  I have the data source properly defined in my tnsnames.ora file and I'm able to connect using SQLPlus and I'm also able to query data via a remote server link in SQL 2008 R2.

  I'm trying to create a data source in BIDS for a new Analysis project. When I try to create a new data source using OracleClient Data Provider, I get the following error:

  "Test connection failed because of an error in initializing provider. 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."

  Anyone encounter this problem before and solve it?

  Thank you,

  Mike

• rufhowse

  Valued Member

  Points: 59

  More actions

  December 9, 2011 at 11:29 am

  #1419558

  You must install both 64 and 32 Oracle clients. Applications use 32 bit, processing uses 64.