关于一个错误的类型,请高手指教!!谢了
我编写了一段关于删除数据表行纪录的代码,总是出现这样的信息,错误类型:Microsoft OLE DB Provider for ODBC Drivers 。第十行。请大家看看我的代码,是否有错误阿。郁闷中!
<%
sn=request.QueryString("sn")
set conn=server.CreateObject("ADODB.Connection")
conn.Mode=3
conn.Open "driver=sql server;server=ly;uid=sa;pwd=;database=ss"
set rs=server.CreateObject("ADODB.Recordset")
rs.LockType=3
rs.CursorType=0
delsql= "delete * from users where sn="&sn
rs.Open delsql,conn
rs.Close
set rs=nothing
response.Redirect("Edituser.asp")
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>删除信息</title>
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="ProgId" content="VisualStudio.HTML">
<meta name="Originator" content="Microsoft Visual Studio.NET 7.0">
</head>
<body MS_POSITIONING="GridLayout">
</body>
</html>