泰国机场出境流程:asp与sql 的无法删除记录问题
来源:百度文库 编辑:中科新闻网 时间:2024/10/02 08:08:28
把access换成sql server后出现无法删除的问题
'---源码---------------------------------------------
id=request("id")
Dim rs, Conn
set rs=server.createobject("adodb.connection")
serverID="127.0.0.1,2433"
serverUser="sa"
serverPass="123"
DataBase="cmpp"
Conn="Provider=SQLOLEDB;Data Source="&serverID&";UID="&serverUser&";PWD="&serverPass&";DataBase="&DataBase
rs.open Conn
response.buffer=true
sql2="delete * from SM_MT where id="&int(id)
set rs=conn.execute(sql2)
response.redirect("usersendroot.asp")
'-------end -------------------------------------
错误提示:
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象: 'Provider=SQLOLEDB;Da'
/admin/rootdelsms.asp,行19
'---源码---------------------------------------------
id=request("id")
Dim rs, Conn
set rs=server.createobject("adodb.connection")
serverID="127.0.0.1,2433"
serverUser="sa"
serverPass="123"
DataBase="cmpp"
Conn="Provider=SQLOLEDB;Data Source="&serverID&";UID="&serverUser&";PWD="&serverPass&";DataBase="&DataBase
rs.open Conn
response.buffer=true
sql2="delete * from SM_MT where id="&int(id)
set rs=conn.execute(sql2)
response.redirect("usersendroot.asp")
'-------end -------------------------------------
错误提示:
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象: 'Provider=SQLOLEDB;Da'
/admin/rootdelsms.asp,行19
删除语句delete在sql中和在access中是不一样的
在sql中delete后面不能加*号!你去掉*号就好了.
改一下这个试试
sql2="delete * from SM_MT where id='"&int(id)&"'"
还有,网页的错误类型提示是什么?