数据库连接的问题,请高手帮忙!!!!送分!!!!
我用ADO连接数据库时用如下代码!!!
Private Sub Form_resize()
With Adodc1
.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog='" & DBname & "';Data Source='" & SVname & "'"
.UserName = URoute
.Password = ********
.CommandType = adCmdText
.CursorLocation = adUseClient
.RecordSource = "select * from [biao]"
.Refresh
End With
End Sub
为什么回出现“[dbnmpntw]commectionopen(createfile())”错误!!
急急!!!!!!!!!!!!!!