新微赢技术网

标题: [求助]Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14' [打印本页]

作者: Bu怕Bu怕 时间: 2010-1-7 00:51
标题: [求助]Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
热心的高手，我作的学位论文远程提交系统，有的学生能顺利提交，有些学生在提交时却出现以下错误：

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]第 9 行: 's' 附近有语法错误。
/paper/paper_submit/subinsert2.asp，行 35

subinsert2.asp 代码如下：
<%
dim tr,strTeacherName,strTeacherDivision,strKeyWords,strPrintYear,strPageNumber,strChinaAbstract,strEnglishAbstract,strfenlei
strTeacherName=request.Form("txtTeacherName")
strTeacherDivision=request.Form("txtTeacherDivision")
strKeyWordsCN=request.Form("txtKeyWordsCN")
strKeyWordsEN=request.Form("txtKeyWordsEN")
strPrintYear=request.Form("txtPrintYear")
strPageNumber=request.Form("txtPageNumber")
strChinaAbstract=request.Form("txtChinaAbstract")
strEnglishAbstract=request.Form("txtEnglishAbstract")
strfenlei=request.form("txtFenLei")

set conn=server.CreateObject("ADODB.Connection")
conn.open"Driver={SQL Server};Server=TSGWEB;Database=paperdata;Uid=sa;Pwd=123"
set rs=server.createobject("ADODB.recordset")

sql="update xwlwtj set Teachername1='"&strTeacherName&"', Danwei1='"&strTeacherDivision&"', KeywordCN ='"&strKeyWordsCN&"',KeywordEN ='"&strKeyWordsEN&"',ClassifyNo='"&strfenlei&"',Datetime='"&strPrintYear&"',Pagenum='"&strPageNumber&"', AbstructCH='"&strChinaAbstract&"', AbstructEN='"&strEnglishAbstract&"',paperState=3 where UserID='"&session("userid")&"'"
conn.Execute(sql) '行35
set rs=nothing
conn.close
set conn=nothing

%>

高手指点了，急需解决！！

欢迎光临新微赢技术网 (http://bbs.weiying.cn/)