Set cn = New ADODB.Connection
Set Rs = New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "driver={sql server};server=172.18.122.199;uid=sa;pwd=123456;database=CAWS600B;timeout=100"
Set Rs.ActiveConnection = cn
If cn.State = adStateOpen Then
cn.Open
Else
MsgBox "数据库连接失败!", 64, "系统提示"
End
End If
这是我连接的代码,请问有什么问题吗?
Set cn = New ADODB.Connection
Set Rs = New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "driver={sql server};server=172.18.122.199;uid=sa;pwd=123456;database=CAWS600B;timeout=100"
Set Rs.ActiveConnection = cn
If cn.State = adStateOpen Then
cn.Open
Else
MsgBox "数据库连接失败!", 64, "系统提示"
End
End If
这是我连接的代码,请问有什么问题吗?