Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

我在编写asp是始终出现这问题,我想请大家帮忙.

<%@ Language=VBScript %>
<%
'取得用户名和密码
name = Request.Form("name")
passwd = Request.Form("passwd")
'根据用户名和密码查询用户信息
sql = "select ppusername,ppuserpasswd,type from ppusername1 where ppusername = name "
set conn = server.CreateObject("adodb.connection")
conn.Open Application("dsn")
set rs = server.CreateObject("adodb.recordset")
rs.Open sql,conn

程序写到上面就出现标题显示的问题了!请大家帮忙.

下面这个是global.asa,我也附上了.
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'定义数据库连接字符串
Application("dsn") = "DSN=newbookware;UID=;PWD=;"
End Sub
</SCRIPT>

[此贴子已经被作者于2006-5-17 19:33:11编辑过]