初学者的问题，请高手帮忙（添加问题）。

Nakata6 2003-07-12 10:45:50

<%
dim cn
dim conn
dim connstr
on error resume next
connstr="driver={SQL Server};server=yy;uid=sa;pwd=99168;database=ku"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

SQLstr="insert into admin(name,ps) values('"& request("name") &"','"& request("ps") &"')"
rs.Execute(SQLstr)
response.write"添加成功"
rs.close
conn.close
%>

添加不了，又没有提示，请各位帮帮忙把。

...全文

20 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

eduxh 2003-07-12

打赏
举报

rs.Execute(SQLstr)主要是这句错了
改成：conn.Execute(SQLstr)

chinesun 2003-07-12

打赏
举报

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加</title>
</head>

<body>
<%
if request("name")<>"" and request("ps")<>"" then
iname=request("name")
ips=request("ps")
dim cn
dim conn
dim connstr
on error resume next
connstr="Provider=SQLOLEDB.1;Password=99168;Persist Security Info=True;User ID=sa;Initial Catalog=ku;Data Source=YOUCOMPUTERNAME;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YOUCOMPUTERNAME;Use Encryption for Data=False;Tag with column collation when possible=False"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

SQLstr="insert into admin(name,ps) values('"& iname &"','"& ips &"')"
conn.Execute(SQLstr)
response.write"添加成功"
conn.close
else
end if
%>

<form method="get" action="tianjiasql.asp">
<p> Name:
<input type="text" name="name" size="20">
</p>
<p>Password:
<input type="password" name="ps" size="20">
</p>
<p>
<input type="submit" value="添加" name="B1">
<input type="reset" value="重置" name="B2">
</p>
</form>

</body>

</html>
___________________
你用的是MS SQLServer2000吧？你要把你的数据库连接字串改改，改成：
connstr="Provider=SQLOLEDB.1;Password=99168;Persist Security Info=True;User ID=sa;Initial Catalog=ku;Data Source=YOUCOMPUTERNAME;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YOUCOMPUTERNAME;Use Encryption for Data=False;Tag with column collation when possible=False"
其中：
Data Source=YOUCOMPUTERNAME;
Workstation ID=YOUCOMPUTERNAME;
中的YOUCOMPUTERNAME是你的机器名称。

<form method="get" action="tianjiasql.asp">
这个是GET或者POST倒是无所谓的。

这样请试试。

pimple 2003-07-12

打赏
举报

<%
dim cn
dim conn
dim connstr
on error resume next
connstr="driver={SQL Server};server=yy;uid=sa;pwd=99168;database=ku"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
SQLstr="insert into admin(name,ps) values('"& request("name") &"','"& request("ps") &"')"
conn.Execute(SQLstr)
response.write"添加成功"
rs.close
conn.close
%>

Nakata6 2003-07-12

打赏
举报

<html>

<%
dim cn
dim conn
dim connstr
on error resume next
connstr="driver={SQL Server};server=yy;uid=sa;pwd=99168;database=ku"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

SQLstr="insert into admin(name,ps) values('"& request("name") &"','"& request("ps") &"')"
conn.Execute(SQLstr)
response.write"添加成功"
conn.close
%>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加</title>
</head>

<body>

<form method="POST" action="tianjiasql.asp">
<p> Name:
<input type="text" name="name" size="20">
</p>
<p>Password:
<input type="password" name="ps" size="20">
</p>
<p>
<input type="submit" value="添加" name="B1">
<input type="reset" value="重置" name="B2">
</p>
</form>

</body>

</html>

怎么还是不行呀，请执教