Brian - I'm starting an OLAP project and am having similar problems. Did
you ever get this resolved? Would you mind sharing how you got it
fixed? I would also like to know how to do MDX with ADO.Net versus ADO
2.7. Have you attempted using ADO.Net yet? I'm having a tough time
finding ADO.Net/MDX/OLAP resources on the web.
Thanks!
>
> I keep getting a COM exception error when I put the following code in a
> VB.Net class and call it. The code bombs on the following line. Any
ideas??
> I have the folloing references named fo the project.
> --Microsoft activex data objects(multidimensional) 2.7 library
> --Microsoft activex data objects 2.7 library
> --system
> --system.data
> --microsoft.visualbasic.compatibility
> --
> cat.let_ActiveConnection("Data Source=local;Provider=msolap;")
>
>
> -
> Dim cat As New ADOMD.Catalog()
> Dim cst As New ADOMD.Cellset()
> Dim i As Short
> Dim j As Short
> Dim strServer As String
> Dim strSource As String
> Dim strColumnHeader As String
> Dim strRowText As String
>
> '*--------------------------------------------------------------
---
> ------
> '* Set Server to Local Host
> '*--------------------------------------------------------------
---
> ------
> strServer = "LOCALHOST"
>
> '*--------------------------------------------------------------
---
> ------
> '* Set MDX query string Source
> '*--------------------------------------------------------------
---
> ------
> strSource = strSource & "SELECT "
> strSource = strSource & "{[Measures].members} ON COLUMNS,"
> strSource = strSource & "NON EMPTY [Store].[Store City].members
ON
> ROWS"
> strSource = strSource & " FROM Sales"
>
> '*--------------------------------------------------------------
---
> ------
> '* Set Active Connection
> '*--------------------------------------------------------------
---
> ------
> cat.let_ActiveConnection("Data Source=local;Provider=msolap;")
>