How to connect MS OLAP as datasource?

[lincon]

In ReportNet cognos connection ,I create a datasoure with others type,the connect string is 'Provider=MSOLAP;Persist Security Info=False;User ID=sa;Data Source=dvt002;Location=test;Mode=ReadWrite;Client Cache Size=25;Auto Synch Period=10000'. Error QE-DEF-0285 Logon failure display when testing connection,but user and password is indeed correct.

How can i connect msolap,someone can tell me,thanks!

 

[CRNUSER]

Hello Lincon,

Are you using MS OLAP cubes in ReportNet?
If yes are running PPES 7.3 and ReportNet 1.1MR1?
Can you connect to your cube in PPES and browser or TOC?
Please explain more about your problem the error message is not enough for fixing the issue.

Regs,

CRNUSER

 

[lincon]

Thank CRNUSER
Error message:
QE-DEF-0285 Logon Failure
QE-DEF-0325 The cause of the logon failure is
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testdatasourceconnection
UDA-SQL-0432 Unable to locate the gateway 'cogudaor=msolap'.