我用VB连接SQL,代码如下
Public rs As ADODB.Recordset
Public db As ADODB.connectionPrivate Sub Form_Load()
Dim t As Integer
Set db = New ADODB.connection
Set rs = New ADODB.Recordset
db.ConnectionString = "Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=admin;Initial Catalog=酒店管理;Data Source=(local)"
db.Open
rs.Open "select rName from 客房类型", db, adOpenStatic, adLockReadOnly
Dim i As String
For t = 0 To Val(rs.RecordCount) - 1
i = Trim(rs.Fields("rName").Value)
rs.MoveNext
Combo1.AddItem i
Next t
rs.Close
End Sub
在Data Source中,只有设置本地的服务器名才能访问,
无论设置是(local)或者是localhost,或着是127.0.0.1都不能访问,怎么才能解决啊!!!
Public rs As ADODB.Recordset
Public db As ADODB.connectionPrivate Sub Form_Load()
Dim t As Integer
Set db = New ADODB.connection
Set rs = New ADODB.Recordset
db.ConnectionString = "Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=admin;Initial Catalog=酒店管理;Data Source=(local)"
db.Open
rs.Open "select rName from 客房类型", db, adOpenStatic, adLockReadOnly
Dim i As String
For t = 0 To Val(rs.RecordCount) - 1
i = Trim(rs.Fields("rName").Value)
rs.MoveNext
Combo1.AddItem i
Next t
rs.Close
End Sub
在Data Source中,只有设置本地的服务器名才能访问,
无论设置是(local)或者是localhost,或着是127.0.0.1都不能访问,怎么才能解决啊!!!
sql server 你自己建了一个用户名叫做 admin么?
一般用sa 用户的嘛
只有在Data Source设置为本机服务器的名字才能够访问,
用(local)或者是localhost,或着是127.0.0.1都不能访问