ASP连接SQL Server数据库一直发生HTTP 500-内部服务器错误

来源:百度知道 编辑:UC知道 时间:2024/05/31 09:26:19
我是Windows 2000 Advanced Server系统,SQL Server 2000 SP4,在 查询分析器 里连接数据库查询一切正常。于是我开始Web设计部分,并写了一个ASP测试页,具体代码如下:

<%
dim rs_sqlSelect
dim str_dataConn
dim str_sqlSelect

set rs_sqlSelect = server.createObject("adodb.recordset")
str_dataConn = "driver={SQL Server};server=localhost;uid=jyrevhs;pwd=1257539742807585;database=dobsta_Data"
str_sqlSelect = "select * from dob where sname = 'admin'"
rs_sqlSelect.open str_sqlSelect, str_dataConn, 1, 1

if not(rs_sqlSelect.bof and rs_sqlSelect.eof) then
response.write rs_sqlSelect("sname")
end if

rs_sqlSelect.close
set rs_sqlSelect = nothing
set str_dataConn = nothing
%>

但是始终打不开页面,IE一直显示HTTP 500 - 内部服务器错误。实在弄不懂我哪个地方有错误,难道代码不对吗?
天呀,我犯了个好笑的错误,这也太有戏剧性了吧!试过所有方法均无效,百般焦急心神不定中,想起创建个DSN桥看行不行。刚创建了一半儿突然恍然大悟,我的上帝呀,database数据库名字竟然写错了,把数据库名与数据文件名混淆了!实际新建数据库时名字是dobsta,系统会自动在数据库文件名后面再加上_Data,而我恰恰是在ASP里面

set rs_sqlSelect = server.createObject("adodb.recordset")
str_dataConn = "driver={SQL Server};server=localhost;uid=jyrevhs;pwd=1257539742807585;database=dobsta_Data"
str_sqlSelect = "select * from dob where sname = 'admin'"
rs_sqlSelect.open str_sqlSelect, str_dataConn, 1, 1

--------------------------------------------------
改成
--------------------------------------------------

set str_dataConn = server.createObject("adodb.connection")
set rs_sqlSelect = server.createObject("adodb.recordset")
str_dataConn.open "driver={SQL Server};server=localhost;uid=jyrevhs;pwd=1257539742807585;database=dobsta_Data"
str_sqlSelect = "select * from dob where sname = 'admin'"
rs_sqlSelect.open str_sqlSelect, str_dataConn, 1, 1

------------------------------

把internet选项--高级--显示友好的url错误 前面的勾勾去掉, 然后刷新页面, 把具体的错误贴出来