Microsoft JET Database Engine '80040e14' FROM 子句语法错误 \10\search1.asp, line 21。这是怎么回事?
来源:百度知道 编辑:UC知道 时间:2024/06/11 12:45:22
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%
dim kind,keyword
kind=request("kind")
keyword=request("keyword")
%>
<%
dim objconn,objrs,sqll
set objconn=server.CreateObject("ADODB.Connection")
objconn.connectionstring="provider=Microsoft.Jet.OLEDB.4.0;"&"Data Source=
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%
dim kind,keyword
kind=request("kind")
keyword=request("keyword")
%>
<%
dim objconn,objrs,sqll
set objconn=server.CreateObject("ADODB.Connection")
objconn.connectionstring="provider=Microsoft.Jet.OLEDB.4.0;"&"Data Source=
sqll="select * from 民谣歌曲where "&kind&" like '%"&keyword&"%'"
需要修改,请在where前面加上空格,字段名和表明如果不是英文,最好加上方括号,比如:
sqll="select * from [民谣歌曲] where ["&kind&"] like '%"&keyword&"%'"
特别注意空格哦,建议你复制吧。
Microsoft Jet打不开文件
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E07) asp
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80004005)错误
Microsoft Jet 数据库引擎打不开文件