Hi
Can anyone give me pointers on how to configure a machine so that it is possible to run .NET applications with Analysis Services?
I will be using HTTP not HTTPS.
Currently I have IIS, Visual Studio and the SQL Server Client connectivity tools. If I look at my installation I can see 2 MSOLAP.DLL files - one of them labelled 9.0.
However I have written an application that attempts simply to connect to my cube and no joy. So I am thinking that I need to do something beforehand to configure ASP.NET to accept OLAP connections.
Just wondering if anyone out there who has coded .NET applications for Analysis Services can point me in the right direction eg
[ul]
[li]Do I need to install any more files[/li]
[li]Should I install the latest .NET ADOMD SDK as currently using the old ADO one[/li]
[li]Do I need to copy the provider file to the virtual directory etc IIS[/li]
[/ul]
Sorry to be so troublesome - I have been trying to find articles on the web that can help me but I am getting more and more confused so any help would be much appreciated!!
Thanks
Nassy
Can anyone give me pointers on how to configure a machine so that it is possible to run .NET applications with Analysis Services?
I will be using HTTP not HTTPS.
Currently I have IIS, Visual Studio and the SQL Server Client connectivity tools. If I look at my installation I can see 2 MSOLAP.DLL files - one of them labelled 9.0.
However I have written an application that attempts simply to connect to my cube and no joy. So I am thinking that I need to do something beforehand to configure ASP.NET to accept OLAP connections.
Just wondering if anyone out there who has coded .NET applications for Analysis Services can point me in the right direction eg
[ul]
[li]Do I need to install any more files[/li]
[li]Should I install the latest .NET ADOMD SDK as currently using the old ADO one[/li]
[li]Do I need to copy the provider file to the virtual directory etc IIS[/li]
[/ul]
Sorry to be so troublesome - I have been trying to find articles on the web that can help me but I am getting more and more confused so any help would be much appreciated!!
Thanks
Nassy