日期:2014-05-17  浏览次数:21150 次

求教 ODBC 驱动程序不支持所需的属性
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

单字写错