conn.asp
<%
dim conn
dim dbpath
set conn=server.createobject( "adodb.connection ")
db= "a.mdb "
DBPath = Server.MapPath(db)
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath
%>
sou.asp
<!--#include file= "conn.asp "-->
<% set rs=server.createobject( "ADODB.Recordset ")
rs.open "SELECT * FORM aaa where user like '% "&request.form( "word ")& "% ' ",conn,1,1 %>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/sou01.asp, 第 3 行
------解决方案--------------------
rs.open "SELECT * FORM aaa where user like '% "&request.form( "word ")& "% ' ",conn,1,1 %>
SELECT * FORM aaa
是
SELECT * FROM aaa
单字写错