sql问题
源代码<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>recordset操作</title>
</head>
<body>
<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.open "dsn=hello"
sqlstr="select * from htable"
rs.open sqlstr,conn,2,1,2
rs=nothing
conn=nothing
%>
</body>
</html>
错误
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误。
/mysecsite/04/recordset.asp, 第 15 行