E_Fail 问题

[pennyzhueng]

开发工具:VB 6.0 数据库:Oracle 8i 操作系统:2000 professional
h.lab_num:[Varchar2];
h.time_enter:[Date]
select distinct h.lab_num,h.time_enter,sum(t.prices) as price1
from mastest t,masthead h
group by rollup (h.lab_num,h.time_enter)
having(h.lab_num is null and h.time_enter is null ) or
(h.lab_num is not null and h.time_enter is null ) or
(h.lab_num is not null and h.time_enter is not null )
当h.lab_num 和 h.time_enter 同时分组的时候会发生 ---
"-2147467259 数据库提供者和其他服务返回E_Fail状态. "
请各高手指点指点.................................................
紧急情况阿...........................................

[pennyzhueng]

开发工具:VB 6.0 数据库:Oracle 8i 操作系统:2000 professional
h.lab_num:[Varchar2];
h.time_enter:[Date]
select distinct h.lab_num,h.time_enter,sum(t.prices) as price1
from mastest t,masthead h
group by rollup (h.lab_num,h.time_enter)
having(h.lab_num is null and h.time_enter is null ) or
(h.lab_num is not null and h.time_enter is null ) or
(h.lab_num is not null and h.time_enter is not null )
当h.lab_num 和 h.time_enter 同时分组的时候会发生 ---
"-2147467259 数据库提供者和其他服务返回E_Fail状态. "
请各高手指点指点.................................................
紧急情况阿...........................................

[wome0001]

我也遇到类似的问题：
在Win2k Server,VB6.0,用ODBC，数据源是DBF,Ado2.6的RecordSet，执行如下SQL：

SELECT a.mark AS mark,'' as choicestr,sum(iif (a.groupid=1,1,0)) AS groupid1,sum(iif(a.groupid=2,1,0)) AS groupid2,sum(iif(a.groupid=3,1,0)) AS groupid3,sum(iif(a.groupid=4,1,0)) AS groupid4,sum(iif(a.groupid=5,1,0)) AS groupid5,-1 As groupid6,-1 As groupid7,-1 As groupid8,-1 As groupid9,-1 As groupid10,sum(1) AS num,avg(a.totalmark) AS avgmark,(5670416 - sum(totalmark))/(70518 - sum(1)) as otheravg FROM item_0_0 a GROUP BY a.mark

共返回131条记录，当取记录到84条时，执行.MoveNext返回如下错误信息：
“数据提供者或其他服务返回 E_FAIL 状态。”
为何出现如此的怪问题，请高手指点。