我用的是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"

将sql语句输出看看，拷贝到查询分析器中运行以下看看结果

你的SQL语句一定有问题！

感觉有点乱啊，看来不管搞么事情一定要打好基本功啊