Re: How to start MDX Sample Application with connection string

Tech-Archive recommends: Fix windows errors by optimizing your registry



"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@xxxxxxxxxxx> wrote in message
news:uSuUQTkWGHA.4972@xxxxxxxxxxxxxxxxxxxxxxx
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



.



Relevant Pages

  • Re: How to start MDX Sample Application with connection string
    ... Kaisa M. Lindahl Lervik ... You are connecting to an Analysis Server -- you should use the correct ... MDX Sample Application ...
    (microsoft.public.sqlserver.olap)
  • Re: Installing a 360 Media Center Extender
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... for use when you're connecting to hot spot wireless networks and the ...
    (microsoft.public.windows.mediacenter)
  • Re: dns & smtp connector
    ... > i havent tried connecting with telnet yet... ... >> server is question manually? ... >> Please do not send email directly to this alias. ...
    (microsoft.public.exchange2000.connectivity)
  • Re: Cannot generate SSPI context - error message
    ... Do you have any idea why the error recently appeared, after connecting the ... Select the Alias tab ... > Jasper Smith (SQL Server MVP) ... >> Larry Mehl ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot sync HP iPAQ via USB
    ... Should read "The IP address is assigned by the connecting device." ... This Posting is provided "AS IS" with no warranties, and confers no rights. ... >> To synchronize a Windows Mobile 5.0 device and ActiveSync 4.1, ... >>> installing DHCP service as I didn't do it in my work PC ... ...
    (microsoft.public.pocketpc.activesync)