"anita" <ARao@nexgenix.com> wrote in message
news:059201c4ad13$a188fdb0$a501280a@phx.gbl...
> Hi,
>
> I am trying to simulate mining model creation in SQL
> Server 2005, using C# in .NET. SQL Server 2005 has
> provided with AMO object model for this purpose. To use
> this object model, it is required to
> reference "Microsoft.AnalysisServices.dll"
> and "Microsoft.DataWarehouse.Interfaces.dll".
>
> The first problem is that when I tried to reference these
> DLLs in my project directly, they failed saying "Not a
> valid assembly or COM component".
>
> From one another posting, I found that these two need to
> be registered using "RegAsm" utility and then exported
> into TLB using "TlbExp" utility.
>
> I have been trying these on 2-3 machines where SQL Server
> 2005 is installed.
> But "Microsoft.DataWarehouse.Interfaces.dll" failed to
> register, while on some machines
> even "Microsoft.AnalysisServices.dll" failed on "TlbExp".
>
> I need to mention that almost all machines where I tried
> this had more than one version of .NET Framework. Should
> this be a problem?
>
> Could anyone tell me how to go about it?
>
> P.S. The two DLLs could be found under the
> location "\Program Files\Microsoft SQL Server\90
> \SDK\Assemblies"
>
> Thanks and Regards,
> anita