还是我。因为一个用户不能连续三次以上回复,只好再注册一个帐号了 #^_^#
请问,我在WebQueryOpen里调用代理,代理代码如下:
Sub Initialize
Dim con As ODBCConnection
Dim qry As ODBCQuery
Set con = New ODBCConnection
con.SilentMode = False
Messagebox "正在连接关系数据库..."
If con.ConnectTo("数据源","用户名","密码") = False Then
Print "连接数据库失败!"
Exit Sub
End If
Print "关系数据库连接成功!"
con.Disconnect
End Sub
为什么一直都不成功呢?到底哪里出现问题了?这个代理哪里有问题?
我是个新手,麻烦高手指点一下,谢谢!!
Dim con As ODBCConnection
Dim qry As ODBCQuery
Set con = New ODBCConnection
con.SilentMode = False
Print "正在连接关系数据库..."
If con.ConnectTo("ODBCSource","sa","123") = False Then //ODBC数据源名、用户名、口令
Print "连接数据库失败!"
Exit Sub
End If
Print "关系数据库连接成功!"
Dim result As ODBCResultSet
Set qry = New ODBCQuery
Set qry.Connection = con
Set result = New ODBCResultSet
Set result.Query = qry
StrSQL = "SELECT * FROM drug"
qry.SQL = StrSQL
If result.Execute = False Then
Print "无法从数据表提取数据!"
Exit Sub
End If
con.Disconnect