我的VB+SQL都能连上了但是就是不能执行,不知道是什么原因,请各位给看看,谢谢
Dim RS As New ADODB.Recordset
Dim strSql As String
Set RS = New ADODB.Recordset
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=sa;Initial Catalog=home;Data Source=(local)"
strSql = "SELECT user_id,password FROM user "
strSql = strSql & "WHERE user_id = 1 "
conn.Open
RS.CursorLocation = adUseClient
RS.Open strSql, conn, 1, 1 /RS.Open strSql, conn, adOpenDynamic, adLockBatchOptimistic (这两种写法都不好用)
总是在RS.OPEN这句有问题
请各位给改改
谢谢