Does anyone know the format of the connection string that works with MDX
Sample Application? When starting it from the command prompt with /?, I get
the following message:
---------------------------
MDX Sample Application
---------------------------
MDXSample Usage:

/C <ConnectionString> Connect to the given data source

/F <FileName> Open the given query file

/R Run all queries in the specified file (requires /F and /C)
---------------------------
OK
---------------------------

If I try starting it with the following parameters...
"C:\Program Files\Microsoft Analysis Services\Bin\mdxsampl.exe"
/C"osl-win-vm201;provider=MSDASQL"

I get the following error:
---------------------------
MDX Sample Application
---------------------------
Unable to establish connection.

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
-------------------------
OK
---------------------------

Same goes for trying to do start it with
"C:\Program Files\Microsoft Analysis Services\Bin\mdxsampl.exe"
/CSERVER=osl-win-vm201;provider=MSDASQL

Does anyone know how the /C parameter should be written? All help
appreciated!

Kaisa M. Lindahl Lervik

"C:\Program Files\Microsoft Analysis Services\Bin\mdxsampl.exe" /C
"Provider=MSOLAP;Data Source=localhost"

You are connecting to an Analysis Server -- you should use the correct
provider...

Thanks,
Akshai
--
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.

"Kaisa M. Lindahl Lervik" <kaisaml (AT) hotmail (DOT) com> wrote

Brilliant! Works like a charm.

Not quite sure where I got the provider=MSDASQL. MSOLAP off course makes
more sense.

Kaisa M. Lindahl Lervik


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote