Microsoft KB Archive/238034

= PRB: ODBC DSN Issue when Browsing Cube Data from OLAP Manager on Remote Client =

Article ID: 238034

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q238034



SYMPTOMS
When browsing cube data on an OLAP server from the OLAP Manager on a remote client computer, the user gets the following message:

Cannot connect to the  data source



CAUSE
This message can appear if the ODBC data source name (DSN) for the OLAP database is not defined on the remote client computer.



WORKAROUND
Define a DSN on the client computer with the same name as the one which has been defined for the cube that you want to browse in your OLAP server. For example, if you are accessing the sample FoodMart database on a remote OLAP server (the DSN is FoodMart) then an ODBC DSN name FoodMart should be defined on the client computer also. The DSN on the client computer should point to the same data source as the DSN defined on the server.

Keywords: kbprb KB238034

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.