sql错误,求解...%set connserver.CreateObject(adodb.connection)conn.open providermicrosoft.jet.
sql错误,求解
...
<%
set conn=server.CreateObject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=c:\Inetpub\wwwroot\test\web.mdb"
set rs=server.creatobject("adodb.recordset")
sql="select * from user"
rs.open sql,conn
...
%>
web.mdb中有user表,运行提示
FROM 子句语法错误
没错啊?
[解决办法]
select * from [user]
