ADOMD.NET - Microsoft SQL Server 2008 Analysis Services - page 601

instance. The reply would be a rowset with one row containing the number of the port
that ADOMD.NET will use to establish the connection. Figure 33.6 shows an illustration of
this operation.

Computer

Analysis Services
Default Instance

ADOMD.NET

Analysis Services
Named Instance

FIGURE 33.6 Find the port number by the name of the instance.

If you are going to work with a local cube, you can just specify the path of the file that
contains the local cube (for example, Datasource=c:\mycube.cub ).

NOTE
ADOMD.NET allows only local cubes in files with a .cub extension.

If you have your data stored on a domain different from the client or outside your
network, the client connects to the server via HTTP. To do this, you can specify a
Datasource property that contains the URL to the XML/A provider. For Analysis Services,
this URL is the full path to the msmdpump100.dll installed on Internet Information Services
(IIS). For example, if you create the virtual directory msolap on IIS and copy
msmdpump100.dll there, you use the following URL in the Datasource property: http:/
/<computer_name>/msolap/msmdpump100.dll. If you are connecting to an XML/A
provider different from Analysis Services, you can similarly specify its URL in the
Datasource property. For example, if you are connecting to XML/A SDK version 1.1, you
can use the following URL: http://<computername>/xmla/msxisapi.dll.