ODBC 驱动程序不支持所需的属性
opendb.asp代码
<%
session.abandon
'Server.ScriptTimeOut=500
function opendb(DBPath,sessionname,dbsort)
dim conn
if not isobject(session(sessionname)) then
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={sql server}; Server=10.10.10.1;UID=sa;PWD=aa;Database=aa"
set session(sessionname)=conn
end if
set opendb=session(sessionname)
end function
%>
default.asp代码
<!--#include file="asp/sqlstr.asp"-->
<!--#include file="asp/opendb.asp"-->
<%
'登录
username=request("username")
password=request("password")
if username<>"" and password<>"" then
'打开数据库查找是否有此用户
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select * from kd_admin_xx where xingming=" & sqlstr(username) & ""
rs.open sql,conn,1
if not rs.eof and not rs.bof then
response.redirect "aaa.htm"
end if
end if
%>
如果在sql="select * from kd_admin_xx where xingming=" & sqlstr(username) & ""改成sql="select * from kd_admin_xx"这样就不会出错,否则会出现"ODBC 驱动程序不支持所需的属性"的错误,位置在rs.open sql,conn,1这一行上
有没有知道是哪里错了的,应该如何解决