这段关于sqlserver 2000的代码有什么问题呢？

[876543214321]

set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [user]",conn,1,3
rs.addnew
rs("username")=trim(request("username"))
rs("userpassword")=md5(trim(request("userpassword")))
rs("useremail")=trim(request("useremail"))
'rs("quesion")=trim(request("quesion"))
'rs("answer")=md5(trim(request("answer")))
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
rs("songhuofangshi")=trim(request("songhuofangshi"))
rs("zhifufangshi")=trim(request("zhifufangshi"))
rs("adddate")=now()
rs("lastlogin")=now()
rs("logins")=1

rs("reglx")=1
rs("jifen")=0
rs("jiaoyijine")=0
rs("sex")=1
rs("userlastip")=Request.ServerVariables("REMOTE_ADDR")
'rs("dadyname")=trim(request("dadyname"))
'rs("welcomeshibuy")=trim(request("welcomeshibuy"))
'rs("MoMname")=trim(request("MoMname"))
'rs("MoMNo")=trim(request("MoMNo"))
'rs("yuchan")=trim(request("yuchan"))
'rs("babysex")=trim(request("babysex"))

'论坛的
rs("face")="userface/image1.gif"
Rs("width")=request("width")
Rs("height")=request("height")
rs("bbstype")=request("bbstype")
rs("userclass")="新手上路"
rs("userWealth")=100
rs("userEP")=50
rs("usercP")=50
rs("lockuser")=0
Rs("showRe")=1
rs("userinfo")="||||||||||||||||||||||||||||||||||||||||||"
rs("usersetting")="1|||0"
rs("titlepic")="level0.gif"
rs("usergroupid")=4

rs.update　'这一行报错，

连着sqlserver 2000数据库，之前因为是连着access，没什么事，转到sqlserver就有些问题


connstr="driver={SQL Server};server=e-city; uid=sa;pwd=123456;database=e-city_new"
conn.Open connstr


'db1="database/data.asp"
Set conn1 = Server.CreateObject("ADODB.Connection")
'connstr1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db1&"")
connstr1="driver={SQL Server};server=e-city; uid=sa;pwd=123456;database=e-city_data"
conn1.Open connstr1

[876543214321]

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
/eshop_new/welcomeuserbuyreg.asp, 第 516 行


浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

页：
POST 259 bytes to /eshop_new/welcomeuserbuyreg.asp

POST 数据:
username=wangsy&userpassword=123456&userpassword1=123456&useremail=[e-mail]&userzhenshiname=zz&MoMNo=1&babysex=0&dadyname=%B8%F6%C8%CB%D3%C3%BB%A7&shouhuodizhi=12&youbian=1&usertel=1&songhu . . .


提示信息。但看上去没什么问题一样，

[876543214321]

另外，我想请问连接sqlserver的几种方式？

哪种更好，

[yhxxy]

是不是你在前台输入时,输入的字符串里面有非法字符啊?比如'等