Hi All,

I am not able to connect oracle database from MS-Analysis Services.

All my Fact tables and Dimension tables are residing on Oracle
database.Both the Oracle database and MS Analysis Services are on the
same server.

I am working on the node and I was able to create the datasource using
"Microsoft OLE DB Provider for Oracle " and the test connection also
succedded but while creating the cubes using the cube wizard it throws
error saying " Connection to the data source Failed".

Any one could help me in this regards.

What are the ways to connect the oracle DB from MS Analysis Services.

Regards
Svel

Quite probably it is because of permissions -- your AS service will be
running as an account that doesn't have permissions to access the Oracle
client components. Usually giving the service account permissions to access
the client components will help...

Can you provide the following information:
- is this 32-bit/64-bit?
- is this AS 2005 or AS 2000?

Thanks,
Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Svel" <ssaravanavel (AT) gmail (DOT) com> wrote

Akshai Mirchandani [MS] wrote:

Thanks for ur reply.

How do I set permissions for client components ?

Analysis Services version I use in AS 2000

Regards
Svel

It is the Windows NT file permissions -- the client components get installed
in some folder on your disk and the permissions that the installer sets for
the components sometimes prevent the service account from accessing them...

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Svel" <ssaravanavel (AT) gmail (DOT) com> wrote