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

See reply to your previous posting.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Liv" <lcastillo (AT) sequelsolutions (DOT) com> wrote