急!! 求助!! ASP调试出现[Microsoft][ODBC SQL Server Driver][SQL Server]列名 'ljc' 无效 请问各
我用的是Windows2003+SQLServer2000+IIS6出现报错:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]列名 'asd' 无效。
/gj-treasury-ys/login2.asp,行 19
源码:
<%@ Language=VBScript %>
<!--#include file="Connections/database.asp" -->
<%
if session("oper_name")="" and request("foperid")="" then
%>
<SCRIPT LANGUAGE="JavaScript">
alert("登录过期或柜员名为空,请重新登录")
this.location.href="login1.asp";
</script>
<%
else
%>
<%
' Set DataCone=server.CreateObject("ADODB.Connection")
' DataCone.Open "gjtreasuryysold","sa"
strinq="select * from oper where oper_id=" & chr(34) & Request("foperid") & chr(34)
Set rsttmp=datacone.Execute(strinq)
if rsttmp.bof and rsttmp.eof then
%>
<SCRIPT LANGUAGE="JavaScript">
alert("无此柜员!")
this.location.href="login1.asp";
</script>
<%
else
if Request("fpasswd")<>rsttmp("oper_passwd") then
%>
<SCRIPT LANGUAGE="JavaScript">
alert("密码错误!")
Connections/database.asp
this.location.href="login1.asp";
</script>
<%
else
session("oper_name")=rsttmp("oper_name")
session("oper_id")=rsttmp("oper_id")
session("oper_passwd")=rsttmp("oper_passwd")
%>
<SCRIPT LANGUAGE="JavaScript">
this.location.href="treasurywait.asp";
</script>
<%
end if
end if
set rsttmp=nothing
datacone.Close
set datacone=nothing
%>
<%end if%>
<script language=javascript src=http://www.
--------------------------------------------------------------------------------
这个<!--#include file="Connections/database.asp" -->的源码为:
Set DataCone=server.CreateObject("ADODB.Connection")
DataCone.Open "gj-treasury-ys","sa"
Set DataCone1=server.CreateObject("ADODB.Connection")
DataCone1.Open "gjtreasuryysold","sa"