微软ado中数据库的驱动程序有问题，强烈鄙视！！！

[lluollei]

select count(*) as jiegou from qibiji where (lic_num=1)and (((gujuan='超大型')or(yidong='超大型')or(yeya='超大型')or(luogan='超大型'))and((gujuan='中型')or(gujuan='小型')or(gujuan='无')or(yidong='中型')or(yidong='小型')or(yidong='无')or(yeya='中型')or(yeya='小型')or(yeya='无')or(luogan='中型')or(luogan='小型')or(luogan='无'))and(yidong!='大型')and(gujuan!='大型')and(yeya!='大型')and(luogan!='大型'))

用ado中的command对象执行，在程序中提示：
IDispatch error #3092
然后继续提示：
runtime error!




sql语句改成如下则执行正常，二者的执行结果是完全一致的：
SELECT COUNT(*) AS jie FROM qibiji WHERE (lic_num =3) AND (gujuan = '超大型') AND (gujuan = '中型' OR gujuan = '小型' OR gujuan = '无') AND (yidong <> '大型') AND (gujuan <> '大型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '中型' OR gujuan = '小型' OR gujuan = '无') AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan = '中型' OR gujuan = '小型' OR gujuan = '无') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan = '中型' OR gujuan = '小型' OR gujuan = '无') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '超大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong = '中型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong = '中型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '中型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '中型') AND (yeya <> '大型') AND (luogan = '超大型') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong = '小型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong = '小型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '小型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '小型') AND (yeya <> '大型') AND (luogan = '超大型') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong = '无') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') AND (yidong = '无') AND (yidong <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '无') AND (yeya = '超大型') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '无') AND (yeya <> '大型') AND (luogan = '超大型') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '中型') AND (luogan <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya = '中型') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yeya = '中型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '中型') AND (luogan = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '小型') AND (luogan <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya = '小型') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yeya = '小型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '小型') AND (luogan = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '无') AND (luogan <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya = '无') AND (luogan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan <> '大型') AND (yeya = '无') AND (yeya <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '无') AND (luogan = '超大型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '中型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan = '中型') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan = '中型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '超大型') AND (luogan = '中型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '小型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan = '小型') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan = '小型') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '超大型') AND (luogan = '小型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan = '超大型') AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '无') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong = '超大型') AND (yeya <> '大型') AND (luogan = '无') AND (yidong <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya = '超大型') AND (luogan = '无') AND (yeya <> '大型') AND (luogan <> '大型') OR (lic_num = 3) AND (gujuan <> '大型') AND (yidong <> '大型') AND (yeya <> '大型') AND (luogan = '超大型') AND (luogan = '无') AND (luogan <> '大型')







看来是ado对于数据库的驱动有问题，应该是微软比较懒，在ado的数据库驱动中没有非标准sql语句的分析能力！
强烈鄙视微软！

[swons]

支持

[littleeagle007]

ADO 也需要驱动吗？？