incorrect syntax near the keyword 'and'
我點查詢時出現錯誤:incorrect syntax near the keyword 'and'
Adodc1.ConnectionString = " Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=axmtwdb;Data Source=192.168.2.200"
Adodc1.CommandType = adCmdText
Adodc1.CursorLocation = adUseClient
Adodc1.CursorType = adOpenKeyset
Adodc1.RecordSource = sSQL
Adodc1.Refresh
Set rs = Adodc1.Recordset
'Refresh'方法('IADODC'物件)失敗
不知道我哪裡還要設置