Question

ADODB.Recordset 错误 '800a0bb9' 参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

各位好我是个新手，刚学asp照着教程做出了点问题，我都不理解是怎么回事，请高手解答~谢谢~

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.Source = "SELECT * FROM user ORDER BY id";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>

ADODB.Recordset 错误 '800a0bb9'

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

/newgn/index.asp，行 5

Answer 1

Recordset1.Source = "SELECT * FROM user ORDER BY id";
Recordset1.ActiveConnection = MM_conn_STRING;
Recordset1.CursorType = 1;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
或
set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1

Answer 2

没有打开记录集

set rs = server.creatObject("adodb.recordset")
sql = "SELECT * FROM user ORDER BY id"
RS.OPEN SQL,MM_conn_STRING,1,1

Answer 3

使用面向对象的SERVER类
set myrs = server.creatObject("adodb.recordset")
这个是关键啊