student.mdb是Access数据库连接串:
DRIVER={SQL SERVER};SERVER=服务器名;DATABASE=数据库名;UID=用户名;PWD=密码例如:
DRIVER={SQL SERVER};SERVER=DBServer;DATABASE=Northwind;UID=sa;PWD=000
DRIVER={SQL SERVER};SERVER=服务器名;DATABASE=数据库名;UID=用户名;PWD=密码例如:
DRIVER={SQL SERVER};SERVER=DBServer;DATABASE=Northwind;UID=sa;PWD=000
Private Sub Form_Load()
DRIVER= {SQL SERVER};SERVER=TT;DATABASE=student;UID=sa;PWD=
End Sub
为什么DRIVER= {SQL SERVER};SERVER=TT;DATABASE=student;UID=sa;PWD= 有语法错误啊?拜托~~
Dim str As String
Dim Cnn As New ADODB.Connection
Cnn.ConnectionString = "DRIVER={SQL SERVER};SERVER=DBServer;DATABASE=Northwind;UID=sa;PWD=000"
Cnn.Open
........
End Sub
Dim str As String
Dim Cnn As New ADODB.Connection
Cnn.ConnectionString = "DRIVER={SQL SERVER};SERVER=TT;DATABASE=student"
Cnn.Open
Dim rs As New ADODB.Recordset
Set re = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.LockType = adLockBatchOptimistic
rs.Open "select * from aaa"
End Sub请问为什么运行的时候 rs.Open "select * from aaa"编译有错误 aaa是我建的一个表
后边的参数 conn,3,2是什么意思?谢谢