读书人

求教 ODBC 驱动程序不支持所需的属性,

发布时间: 2012-04-01 17:23:46 作者: rapoo

求教 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

单字写错

读书人网 >ASP

热点推荐