我用asp连接sybase数据库，在查询时，我限制的时间间隔小，能正常运行，但时间间隔大时，就不能运行。请帮忙

上面写得不好理解,能不能看下源码?

set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select distinct a.ask_id as ask_id, e.area_id as area_id,convert(char(11), min(b.ask_date), 111) + convert(char(11), min(b.ask_date), 108) as ask_date, convert(char(11), max(b.state_date), 111) + convert(char(11), max(b.state_date), 108) as state_date,a.busi_detail_id as busi_detail_id, e.site_id as site_id,e.name as name1,d.staff_id as staff_id,d.name as name2, 0.00 as income,0.00 as deposit, a.process_flag as process_flag, serv_name, b.acc_nbr as acc_nbr, max(delieve_tache_date) as delieve_tache_date,a.serv_id as serv_id, a.order_id as order_id from serv_info_ask b,exec_order_his_A a, staff d, site e where b.ask_date between '"&start&"' and '"&finish&"' and d.site_id = e.site_id and b.ask_staff_id = d.staff_id and b.serv_id = a.serv_id and d.state='10A' and e.state='10A'group by b.serv_id having b.serv_id = a.serv_id and b.ask_staff_id = d.staff_id and d.site_id = e.site_id and b.transaction_id = max(b.transaction_id)"
rs.Open rs.Source,conn,1,1
between '"&start&"' and '"&finish&"'两个变量时间跨度一大，就会出现错误。请大家提宝贵意见

是不是数据量太大了 执行超过90秒了？

我把时间设置的已经很大了。提示错误也不是超时。

能不能再看看提示的错误参数,是怎么样子呢?因为一般调试时从他提示的错误参数下手很方便

[此贴子已经被作者于2006-7-6 15:36:11编辑过]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC 驱动程序不支持所需的属性。

/ys/gd.asp，行78
78行已经在上面发表了