这是我的连接代码,请帮帮忙!!!Private Sub Form_Load()
Dim db As ADODB.Connection
Dim rs As ADODB.Recordset
Set db = New ADODB.Connection
db.Provider = "sqloledb"
db.ConnectionString = "user ID=sa;data source=jingdianxia2;initial catalog=pubs"
db.Open
Debug.Print db.StateSet rs = New ADODB.Recordset
rs.ActiveConnection = db
rs.Open "select * from authors"End Sub
Dim db As ADODB.Connection
Dim rs As ADODB.Recordset
Set db = New ADODB.Connection
db.Provider = "sqloledb"
db.ConnectionString = "user ID=sa;data source=jingdianxia2;initial catalog=pubs"
db.Open
Debug.Print db.StateSet rs = New ADODB.Recordset
rs.ActiveConnection = db
rs.Open "select * from authors"End Sub
如我的为
Data Source=210.46.97.77
[DBNMPNTW]拒绝访问
是不是SQL设置或是网络设置的问题?
然后将你的代码改为:db.ConnectionString = "file dsn=jingdianxia2;uid=sa;pwd="""