一个小程序,连接短信网关,登陆没有问题,可是一发送短信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.HelpContextEnd Sub
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.HelpContextEnd Sub
解决方案 »
- VB对话框控件
- VB6。0 连ACCESS要添加什么引用?
- 我直接处理msgbox Err.Number,系统就报错,这是为啥.
- 一个好奇怪的东西!急急急!!!
- VB 同时控制两个串口
- DrawText哪里错用了啊
- help!我想要24小時制的時間,SQL數據庫中存的是24小時制的,紀錄集取出來的時間卻總是"2001/11/11 上午 11:11:11"這種格式,又不想用 "控制面板中設置機器時間格式" 和 "自己寫個函數對每條紀錄的時間格式化" 的方法!!!
- 用kill 怎么删除一个目录啊?
- 急!如何用ADO在ACCESS 表中建一个“自动编号”字段?
- spread8表格控件导致winform不能通过一个form上的按钮单击事件显示另一个form??!!
- 100分高分求救:关于网页的处理问题
- 菜鸟请教ListView问题,帮帮忙~~~
Set rstSend = New adodb.Recordset另外不要用ADDNEW的方法,用INSERT INTO的SQL语句执行效率高,你试试
事件查看器里面还没有记录to gordon1979(CGD) : 权限我是有的
单步debug~
错误处理都用不上。只要一点击发送按钮,就会弹出对话框:“vb6产出了错误,会被windows关闭。你需要重新启动程序。正在创建错误日志 。”事件查看器里面没有错误日志阿,请问怎么查看?
Private Sub cmdConnect_Click()
' On Error GoTo errmsg
Dim ret As Boolean
ret = IFInitInterface(5, 1, "211.xx.xx.xx 7890 5000") '初始化
If ret = True Then
'cmdLoggin.Enabled = True
MsgBox "初始化成功", vbOKCancel, "连接网关"
cmdExit.Enabled = True
Else
MsgBox "初始化失败"
End If用步进debug运行了
ret = IFInitInterface(5, 1, "211.137.207.101 7890 5000") '初始化
显示 ret的值为true,竟然弹出“初始化失败”的消息框??