請你call下這個簡單的VB程式,為什麼會報錯呢?
Sub ConnDb()
Dim sqlStr
Dim rs As ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Driver=SQL Server;Server=itsql;" & _
"Uid=管理員;Pwd=admini;databse=peoatt"
conn.Open
' MsgBox conn.State
'End
sqlStr = "select * from p_userM "
rs.Open sqlStr, 3 '這行有報錯 For i = 1 To rs.RecordCount
MsgBox rs("u_name") & vbCrLf
rs.MoveNext
If rs.EOF Then Exit For
Next
rs.Close
End Sub
Sub ConnDb()
Dim sqlStr
Dim rs As ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Driver=SQL Server;Server=itsql;" & _
"Uid=管理員;Pwd=admini;databse=peoatt"
conn.Open
' MsgBox conn.State
'End
sqlStr = "select * from p_userM "
rs.Open sqlStr, 3 '這行有報錯 For i = 1 To rs.RecordCount
MsgBox rs("u_name") & vbCrLf
rs.MoveNext
If rs.EOF Then Exit For
Next
rs.Close
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货