"liv" <lcastillo@sequelsolutions.com> wrote in message
news:0c8801c35cb5$4b603ca0$a101280a@phx.gbl...
> Hi!
> I generated an MDX statement in my vb.6 application. The
> query works when i run it in the MDX Sample Application.
> However, when I tried running it in my vb6 application, I
> keep getting this error and when I checked my cellset's
> state, it is equal to 1. What am I doing wrong? Please
> help.
>
> Thanks in advance.
>
>
> Liv
>
> sample code:
>
> everything works until oCellSet.Open strMDX -- strMDX is
> my MDX query.
>
> m_strMDXConnectString = _
> "Provider=MSOLAP.2;USER ID=user;Password=123;"
> & _
> "DATA SOURCE=server01;INITIAL
> CATALOG=sampleCUBE;"
>
> Dim oCellSet As New ADOMD.Cellset
> Set oCellSet = New ADOMD.Cellset
>
> oCellSet.ActiveConnection = m_strMDXConnectString
>
> oCellSet.Open strMDX
> Debug.Print strMDX
>
> MsgBox "state = " & oCellSet.State
>