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
