苦恼中!!!!,VB中执行数据库操作SQL语句,时间过长导致执行错误如何办?????
Conn.ConnectionString = "Provider=SQLOLEDB.1;Password=ynhl95sms;Persist Security Info=True;User ID=sa;Initial Catalog=Report;Data Source=INFOHL95"
Conn.Open
istr = "update temp_bill set qh=(select c3 from ynyd where substring(phone,1,7)=substring(c1,1,7)) where ftype='0201' or ftype='0202'"
Conn.Execute istr
这个语句没有错,在分析查询窗口执行没有问题只是执行时间过长,但是在VB中就会出错,提示
实时错误'-2147217871 (80040131)',超时已过期
如何才能解决这个问题???