I am trying to create a local olap cube.

But I am having some problem with the connection part-- specifically the provider...

I have coded the following lines--

sSourceDSN = "SOURCE_DSN = ""Provider=Microsoft OLE DB Provider for Oracle;DATA SOURCE=ORACLE;USER ID=" & strUserName & ";PASSWORD=" & strPassword & ";"""

adocon.Provider = " Microsoft OLE DB Provider for Oracle "

I want to connect this cube to the oracle database.

But the error gives a msg -saying provider is incorrect ...

Pls suggest some solutions...

Thnx a million