Class not registered when opening AdomdConnection

I'm just getting started on Analysis Services.

I have installed AS on our SQL Server (2000), and I can access it with Analysis Manager and third-party tools. But when I try to open a connection with ADOMD.NET, I get a "class not registered" error message (error ID = -2147221164).

Here's my code:

AdomdConnection conn = new AdomdConnection();
conn.ConnectionString = "Data Source=Servername;Initial Catalog=MyCatalog;ConnectTo=8.0";
conn.Open(); // exception is thrown here

I have installed Visual C# 2005 Express, MSXML 4.0 SP2, and ADOMD.NET (from the SQL Server 2005 Feature Pack).

Daniel

did you ever resolve this. I get the same issue?

thx

Avi

|||

ADOMD.NET (9.0) that comes with SQL2K5 cannot connect directly to AS2K. It delegates to PTS 8.0. What I think you are seeing is that it isn't available. Try installing PTSLITE.EXE from your SQL2K SP4 (AS distribution) kit (located in the \msolap\install\pts subfolder).

_-_-_ Dave

sqlsql