Hi,
The source DB is in Oracle 9.i . I use the native pilot from Oracle. The connection test is OK. I can also explore the data in the Data Source View whithout any problem. But when I try to process the dimension, I get the error message "OLE DB error: OLE DB or ODBC error : Access denied.." . I tried with the Native pilot from MS for Oracle but got the same result.
Could anyone help me ?
Rg.
In your datasource try to use Microsoft OLEDB Provider for Oracle or .NET Oracle Client Data Provider.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi,
Edward, thanks for the fast answer.
with the MS provider and had the error :|||
During deployment of dimensions ( and cubes as well ) Analysis Server tries to process these dimensions. And for that it need to read data from Oracle.
The problem looks like related to the configuration of Oracle client. Also a good idea to check access permissions to Oracle database. See also if changing service account for the Analysis Server solves your problem.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Edwards,
I changed the service account in the "SQL server configuration manager", for Analysis services and now it works fine :D
Thanks for your help,
Sbastien
