Dim CN As New ADODB.Connection Dim RsInfo As New ADODB.RecordsetPrivate Sub Form_Load() CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=test;User Id=sa;Password=sa;" CN.Open RsInfo.CursorLocation = adUseClient RsInfo.Open "select * from user", CN, adOpenDynamic, adLockBatchOptimistic MsgBox (RsInfo.RecordCount) Set CN = Nothing Set RsInfo = Nothing End Sub
dim con as adodb.connection set con =new adodb.connection con.connectionstring="driver={sql server};server=ip地址;database=数据库名;uid=用户 ;pwd=密码" con.open
Dim RsInfo As New ADODB.RecordsetPrivate Sub Form_Load() CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=test;User Id=sa;Password=sa;"
CN.Open
RsInfo.CursorLocation = adUseClient
RsInfo.Open "select * from user", CN, adOpenDynamic, adLockBatchOptimistic
MsgBox (RsInfo.RecordCount)
Set CN = Nothing
Set RsInfo = Nothing
End Sub
set con =new adodb.connection
con.connectionstring="driver={sql server};server=ip地址;database=数据库名;uid=用户
;pwd=密码"
con.open
看不出有什么错误,对不对你可以运行一下你的程序,看运行时有没有错误就知道有没有错了。