一个很小的SQL SERVER2000问题!
hzc1 2003-07-30 06:29:33 各位,对不起了,才开始弄这个SQL,有很多不明白的地方请各位多帮帮忙!
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=cv;Data Source=CD;pwd=SA;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from user", CN, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = Rs
运行时报错,说运行错误‘-2147217900(80040e14),在关键字“user“附近有语法错误。