我试试看使用VB对SQL2K数据库中的数据进行更新,可是老是同时超时,代码如下.谢谢!Dim cnn As Connection
Set cnn = New Connection
link = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=service;Data Source=192.168.1.1"
cnn.Open link
sql = "update user_master set area="A区域" where customer_code="A100"
cnn.Execute sql
Set cnn = New Connection
link = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=service;Data Source=192.168.1.1"
cnn.Open link
sql = "update user_master set area="A区域" where customer_code="A100"
cnn.Execute sql
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货