只是查询数据库,会让vb产生错误,退出?
一个小程序,连接短信网关,登陆没有问题,可是一发送短信vb就产生错误
form_load里面,我是这样定义的
Private Sub Form_Load()
Set conYl001 = New Connection
Set rstSend = New Recordset
With conYl001 '定义连接对象的属性
.Provider = "sqloledb"
.ConnectionString = "user id =sa;password=fjdksla;" & "data source=yl002;" & "initial catalog=yl001;"
.Open
End With
With rstSend '定义记录集属性
.CursorLocation = adUseServer
.CursorType = adOpenDynamic
.LockType = adLockPessimistic
End With
End Sub
发送短信
Private Sub cmdSend_Click()
On Error GoTo errmsg
Dim ret As Byte
Dim destaddr As String '目标地址
Dim userdata As String '发送的短信内容
Dim udlen As Long '数据长度
Dim smid As Long '返回的短信编号
Dim FCS As Byte '返回失败原因
rstSend.Open "select mobile ,content,smsflag from send where smsflag=0 order by id desc", conYl001, 1, 3
'循环发送短信语句
Do While Not rstSend.EOF
rstSend.AddNew
userdata = rstSend.Fields("content")
destaddr = rstSend.Fields("mobile")
udlen = Len(userdata)
'调用发送短信的函数
ret = SubmitAExEx(2, 1, "99999", 2, 1, "13733333333", 0, 0, 0, 0, 0, 8, 0, "2004/12/07 14:55:00", "2004/12/07 14:55:00", 0, 0, udlen, userdata, "service_type ", 0, 0, 0, 0, 3, "999999", "01", destaddr, 20, 1, destaddr, smid, FCS)
rstSend.Update
rstSend.Fields("smsflag") = 1
rstSend.MoveNext
Loop
errmsg:
MsgBox "error " & Err.Number & " error des " & Err.Description & " error help " & Err.HelpContext
End Sub