最简单制毒方法:请高手指点ASP:HTTP 错误 500.100 - 内部服务器错误 - ASP 错误

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 19:24:11
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝
/query.asp, 第 16 行

前面代码:
<% Option Explicit %>
<%
'接受表单输入的数据
Dim userName
userName=Request.Form("txtUserName")
'Response.write"username is:" & UserName

%>

<% Dim strDsn
Dim connDemo
strDsn ="driver={sql server};server=127.0.0.1;Database=XSCJ;UID=LOG1;PWD=999"
Set connDemo= Server.CreateObject("ADODB.Connection")
connDemo.Open strDsn

Dim rsUsers
Dim strSqlSelectUsers

Set rsUsers=Server.CreateObject("ADODB.Recordset")
strSqlSelectUsers="select * from XS where 姓名 like '%"& userName & "%'"
'strSqlSelectUsers="select * from XS where 姓名="& userName

'strSqlSelectUsers="select * from XS where 姓名= '"& userName &" ' "
'connDemo.Execute strSqlSelectUsers

rsUsers.Open strSqlSelectUsers, connDemo

'Response.Write""&rsUsers.RecordCount&""

%>

<!--OUTPUT-->

sql server没有设置好。或者没有连接,