I am currently using ado 2.1 with adomd 1.0 to create local cube files.
I am using the PASSTHROUGH option to connect to my relational database to create MOLAP cubes. Everything works fine until I try to get member properties into my ".cub" file. Whenever I try this, I get an error message saying 'An unexpected internal error has occurred.' I am pretty sure the syntax is correct. Is this supposed to work?

Create Cube :
CubeName
(
DIMENSION Region,
LEVEL Region OPTIONS(SORTBYKEY),
DIMENSION Target,
LEVEL Target,
DIMENSION Geography,
LEVEL Total TYPE ALL,
LEVEL Geography,
PROPERTY [Short Name],
MEASURE [Total X] Function Sum Format '0',
MEASURE [Target X] Function Sum Format '0')

Insert Into:
CubeName
(
Region.Region.NAME,
Region.Region.KEY,
Target.Target,
Geography.Geography.NAME,
Geography.Geography.[Short Name],
Measures.[Total X],
Measures.[Target X]
)
OPTIONS PASSTHROUGH select
l.gt_name,
LPAD(l.gtl_id, 5, '0') || LPAD(l.gt_id, 5, '0'),
i.pd_name,
decode((select level_type from geotrade_levels z where z.id = a.gtl_id), 'STORE', b.STR_NAME || decode(b.STR_NMBR, null, '', ' ' || b.STR_NMBR) || ' :' || decode(b.ADDR, null, '', b.ADDR) || ': ' || decode(b.CITY_STATE, null, '', b.CITY_STATE) || ': ' || decode(b.ZIP, null, '', b.ZIP), b.NAME),
b.NAME,
a.gt_count,
h.target_count
from
t_tr_counts_temp_ a,
t_ttarget_temp_ h,
t_pd_names_ i,
t_r2c_ b,
t_region_names_ l
where
a.gt_id = h.gt_id and
i.pd_id = h.tr_pd_id and
i.ds_id = '1' and
b.gt_id = a.gt_id and
h.reg_gtl_id = l.gtl_id and
h.reg_gt_id = l.gt_id