急!请高手请进!关于注册的问题!
我想把用户注册信息写到数据库中!,请问怎么办!
reg.asp的代码:
<HTML>
<HEAD><TITLE>ASP实例</title></head>
<body>
<form name="form1" method="post" action="reg1.asp">
姓名:
<input type="text" name="name">
<br>
密码:
<input type="password" name="psw">
<br>
<br>
性别:
<input type="radio" name="sex" value="男">
男
<input type="radio" name="sex" value="女">
女 <br>
<br>
城市:
<select name="city">
<option value="上海" selected>上海</option>
<option value="北京">北京</option>
</select>
<br>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</form>
</body>
</html>
reg2.asp页的代码为:
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<%
name=request.form("name")
psw=request.form("psw")
sex=request.form("sex")
city=request.form("city")
Set DataCon=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
DataCon.ConnectionTimeout=20
DataCon.Open "DSN=guestbook_server;uid=sysdy;pwd=185898"
sqlquery="select * from reg_info where name='"&name&"'"
set rs=datacon.execute(sqlquery)
if not rs.eof then
Response.Write "<html><body><center><font size=5>您的名字已经有人在使用。</font></center></body></html>"
else
sqlstr="insert into reg_info(name,pwd,sex,age,email,QQ)"
sqlstr=sqlstr & "values('"&name&"','"&pwd&"','"&sex&"','"&age&"','"&email&"','"&QQ&"')"
DataCon.Execute(sqlstr)
end if
response.write name
response.write psw
response.write sex
response.write city
%>
</body>
</html>
可是错误信息为:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/reg1.asp, 第 16 行
快帮我!