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

[tianyan316]

提示：实时错误'-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

[贝隆]

说了这么多，就是不支持某个属性。

有可能是权限问题，你看看用户名和权限设置OK了吗？

[tianyan316]

[Quote=引用楼主 tianyan316 的回复:]
提示：实时错误'-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,o……
[/Quote]

不是权限的问题``这个可以确认，而且后者我条件多一点就没问题