I have connected my SSAS in SQL server 2008 to an Oracle database. I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube. Now everything was going fine. I could connect to the Oracle
Database and I could see my tables and pull them into the DSV.
But. When I come to process the Cube it throws these errors. Why all of a sudden do the connection objects stop working?
Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'.
Can anyone help here please?
View Complete Post