菜鸟求救
我是单机2000下asp+sql server 2000的配置,
我编写了一个简单的asp程序,是这样做的
1,创建数据库
2,连接odbc数据源时,在sql如何验证登录id的真伪时,我选择sql server 验证,
但是回出现下面的对话框,
“连接失败:
sqlstate:'28000'
sql server 错误:18452
[microsoft][odbc sql server driver][sql server]用户‘1’登录失败。
原因:未与信任sql server连接相关联。”(用户‘1’是我的用户名)
但当我用windows nt 认证模式时,在测试asp时,却出现以下的画面,
"microsoft ole db provider for
odbc drivers 错误'80004005'
[microsoft][odbc 驱动程序 管理器]
未发现数据源名称并且未指定默认驱动程序
/1.asp,行26
请问我到底错在哪里?
3,我的asp原文件是
<% language=vbscript%>
asp与sql server 2000数据库连接事例
classmates数据表的信息
name |
jtdz |
tele |
oicq |
gzdw |
dwdh |
<%
dim strsql
dim conn,classmatesrs
dim strconn
set conn=server.createobject("adodb.connection")
set classmatesrs=server.createobject("adodb.recordset")
conn.open "dsn=classmates"
classmatesrs.open "select * from classmates",conn
do while not classmatesrs.eof
response.write ""
response.write "" & classmatesrs.fields("name")&" | "
response.write "" & classmatesrs.fields("jtdz")&" | "
response.write "" & classmatesrs.fields("tele")&" | "
response.write "" & classmatesrs.fields("oicq")&" | "
response.write "" & classmatesrs.fields("gzdw")&" | "
response.write "" & classmatesrs.fields("dwdh")&" | "
response.write "
"
classmatesrs.movenext
loop
response.write"
"
classmatesrs.close
set classmaters=nothing
conn.close
set conn=nothing
%>
Text[b]“连接失败:Text