实时错误'-2147217887（80040e21）'，ODBC驱动程序不支持所需属性

提示：实时错误'-2147217887（80040e21）'，ODBC驱动程序不支持所需属性
在VB中运行SQL语句是出现该问题：
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color  ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange  ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt  left join  (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from(  select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all  select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount  FROM  SWGOODS_TABLE SW  WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by  storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname  and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size   and At.order_status = '已下单' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno只有其中的条件当我只单选择“已下单”条件时则会报错`，但是我把该语句放在SQL中直接运行不会报错能正常运行
以下语句我加一个筛选条件得出的语句则是正常的`
select ORDER_NO,ORDER_CUSTOMER,ORDER_PO,ORDER_INDENTNO,Order_goodsname,order_item,order_color,order_size,order_count,yy,order_time,order_deldate,order_urgency,order_status,order_ischange,order_iscancel,order_PBno,order_user,order_keytime from (SELECT Order_no,order_customer,Order_po,order_indentno,Order_goodsname,Order_item,Order_color  ,order_size,Order_count,isnull(tx.yy,0) as yy,order_time,order_deldate,order_urgency,order_status,order_ischange  ,order_iscancel,order_PBno,order_user,order_keytime FROM Order_table tt  left join  (select storedata_goodsname,storedata_item,storedata_color,storedata_size,sum(storedata_counts) as yy from(  select ta.storedata_goodsname,ta.storedata_item,ta.storedata_color,ta.storedata_size,ta.storedata_counts from storedata_table ta union all  select sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,SWGOODS_SIZE,-sum(sw.SWGOODS_COUNT)as SWGOODS_tatalcount  FROM  SWGOODS_TABLE SW  WHERE SW.SWGOODS_SIGN='待出货' group by sw.SWGOODS_GOODSNAME,SW.SWGOODS_ITEM,SW.SWGOODS_COLOR,
SW.SWGOODS_SIZE)x group by  storedata_goodsname,storedata_item,storedata_color,storedata_size)tx on tx.storedata_goodsname=tt.order_goodsname  and tx.storedata_item=tt.order_item and tx.storedata_color=tt.order_color and tx.storedata_size=tt.order_size)At ,size_table st where st.size_name=at.order_size   and At.order_status = '已下单' and convert(datetime,AT.order_time) between '2010-10-19' and '2010-10-19' order by at.order_goodsname,at.order_item,at.order_color,st.size_px,at.order_po,at.order_indentno