语法错误(求大神帮忙)
本人新手,求大神帮忙
以下是程序的一段
db.Open "Provider=SQLOLEDB;DATABASE=master;UID=sa;PWD=sa123456"
SQL = ("select l,v from table5")
rs.Open SQL, db, 1, 3
Label4.Caption = rs.Fields("l")
Label6.Caption = rs.Fields("v")
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
调试时,光标停于 rs.Open SQL, db, 1, 3
显示 =号附近有语法错误
本人没闹懂,求大神帮忙改改
[解决办法]
"Provider=SQLOLEDB;DATABASE=master;UID=sa;PWD=sa123456"
这个连接字符串有问题啊