ORACLE网页打不开,高手帮忙看看

[yiyong206]

我有一个网页是连ORACLE数据库的,一个是用MS的驱动(服务器),一个是用ORACLE的驱动(我自已电脑)

现在我同一个网页,数据量比较大,SQL运行时间有几十秒.
我用本机运行的时候时间再长也不会出现问题,但是用服务器来运行这个程序就会提示如下错误:

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/sbserp/manufacture/manufacturecost/cost_analyse.asp, 第 187 行

我连接驱动如下:
服务器:(WINDOWS2000)
myDSN = "Driver={Miscrosoft ODBC for Oracle}; Data Source=topprod;User ID=sbs;PASSWORD=sbs;"

本机:(WINDOWS XP)
myDSN = "Provider=OraOLEDB.Oracle.1;Data Source=topprod;User ID=sbs;PASSWORD=sbs;Persist Security Info=True"


我这连的SQL如下

select  substr(ima01,1,1),case when substr(ima01,1,1)='D' then  '塑钢' 
            when substr(ima01,1,1)='M' then  '金属'
            when substr(ima01,1,1)='N' then  '尼龙'
            when substr(ima01,1,1)='T' then  '拉片'
            when substr(ima01,1,1)='J' then  '模具' end  type,round(sum(ccc23a*oeb12)/sum(oeb12),4) 材料成本 ,round(sum(ccc23b*oeb12)/sum(oeb12),4) 人工成本,
             round(sum(ccc23c*oeb12)/sum(oeb12),4) 制费成本,round(sum(ccc23d*oeb12)/sum(oeb12),4) 加工成本,round(sum(ccc23e*oeb12)/sum(oeb12),4) 其它成本,
             round(sum(ccc23*oeb12)/sum(oeb12),4) 合计成本,round(sum(oeb13)/sum(oeb12),4) 销售单价,round(sum(oeb13)/sum(oeb12) - sum(ccc23*oeb12)/sum(oeb12),4) 毛利
from (
  select ima01,ccc23,ccc23a,ccc23b,ccc23c,ccc23d,ccc23e,sum(oeb12*oeb13*oea24) oeb13,sum(oeb12) oeb12
    from oay_file,ima_file,ccc_file,oeb_file,oea_file
   where oea01 = oeb01
     and ima01 = oeb04
     and oeb04 = ccc01
     and oeb12 > 0
     and oeb13 > 0
     and year(oea02) = ccc02
     and month(oea02) = ccc03
     and ima06 = '0601'
     and oay24 = 'N'
     and substr(oea01, 1, 3) = oayslip
     and oea02 between to_date('110201', 'yymmdd') and to_date('110228', 'yymmdd')
   group by ima01,ccc23,ccc23a,ccc23b,ccc23c,ccc23d,ccc23e
)
group by substr(ima01,1,1)