Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'add' 附近有语法错误。

/reg_save.asp，行 89

错误文件源代码如下
[free]        78                if add = "" Then add = "未填"
        79                Rs("add")=add
        80                Rs("ip")=getip
        81                if Application(CacheName&"_WebSetting")(17)="1" Then
        82                        Rs("mark")="0" '审核后通过
        83                        Temp="<script>alert('您提交的注册资料成功，请等待管理员审核！');location='user.asp'</script>"
        84                Else
        85                        Rs("mark")="1" '直接通过
        86                        Temp="<script>alert('恭喜您注册成功，请登陆会员中心！');location='user.asp'</script>"
        87                End if
        88                Rs("zcdate")=Now()
        89                Rs.update
        90                CloseRs
        91                UserID=Conn.Execute("Select Top 1 ID From [China_User] Order By ID Desc")(0)
        92                If Strint(Application(CacheName&"_Setup")(3))>0 Then S_Integration 1,Application(CacheName&"_Setup")(3),UserID,"注册奖励"
        93                Response.Write Api_SaveCookie
        94        End if
        95        CloseConn
        96        Response.Write Temp%>[/free]

帮忙解决下阿

[[it] 本帖最后由 时尚网络 于 2008-11-24 01:55 编辑 [/it]]

楼主太勤快了...半夜近两点了还在码字.

add是关键字..你把相关的add改成别的先..比如

  if add1 = "" Then add1 = "未填"
        79                Rs("add1")=add1

要注意你设置的变量最好不要与asp及sql中的关键字冲突..不然会比较烦人一些.