Showing posts with label amo. Show all posts
Showing posts with label amo. Show all posts

Saturday, February 25, 2012

Can I use AMO from .net 2003?

I'm working with SQL server 2005 beta 2 from C# 2003
I want to know if I can somehow work with amo ?

I would really appreciate any kind of sugestionAMO (Microsoft.AnalysisServices.dll) is built and works with .net framework 2.0, so you will not be able to use it with Visual Studio 2003 (that uses .net framework 1.1).

SQL Setup 2005 install .net framework 2.0, so you can build AMO applications from command line with csc.exe. Or use Visual Studio 2005 Beta 2 (http://lab.msdn.microsoft.com/vs2005/).

Adrian.

Can I Use ADOMD or AMO In ASP.NET 2.0

Hi~

I know some function can be used in debug mode,like MsgBox()...,in ASP.NET 2.0.

But I don't know that Can ADOMD or AMO be used in ASP.NET 2.0.

Could someone tell me?

thanks~

Server: SQL Server 2005

OS: Windows 2003

Yes you can use both ADOMD and AMO from ASP.NET. The main "trick" is to get the code executing as a user that has the approriate rights to access the required SSAS objects. Setting up your application pool up to run under a domain account that is in appropriate SSAS roles is one way of getting this to work.