Methods for accessing data mining databases on other machines through the network:
Perform the following configuration on the data mining database machine:
1. Install xmlasdk. MSI. (Download from Microsoft website)
2. Set the directory under the "msxisapi. dll" file under the installation directory to a virtual directory: "xmla" and grant the "execution" permission to this directory. (This directory can be accessed anonymously .)
3. Access "http: // 127.0.0.1/xmla/msxisapi. dll" through IE directly, and an XML page should be returned.
4. Add the Data Warehouse's everyone access permission.
==========
Client:
1. Installation: adomd. net. MSI. (Download from Microsoft website)
2. add reference to C #: Microsoft. analysisservices. adomdclient
MainProgramCode:
String connstring = "datasource = http: // localhost/xmla/msxisapi. dll; provider = msolap; initial catalog = tutorial ";
Conn = new adomdconnection (connstring );
Conn. open ();
Adomdcommand cmd = conn. createcommand ();
Cmd. commandtext = textbox1.text;
Cellset cset = cmd. executecellset ();
Source Code download: Download