请大家帮忙查找一个错误

[cyljay]

dim college_pro2_rs3
dim college_pro2_constr3
set college_pro2_rs3=Server.CreateObject("adodb.recordset")
college_pro2_constr3="select * from college where college_id="& rs1("college_id") &""
college_pro2_rs3.open college_pro2_constr3,conn,1,1
if not college_pro2_rs3.eof then
do while not college_pro2_rs3.eof

提示这句有错college_pro2_rs3.open college_pro2_constr3,conn,1,1

Microsoft OLE DB Provider for ODBC Drivers '80040e21'
ODBC 驱动程序不支持所需的属性。

[hookee]

Response.Write college_pro2_constr3 输出看下sql语句是否正确?

Response.Write conn.State 看下连接的状态

[lzp4881]

报Microsoft OLE DB Provider for ODBC Drivers '80040e21' 错误,应该是:

sql语句出错(数据类型不匹配或表名(字段名)错误或表处于编辑状态，或表不存在于conn打开的数据库中)

[cyljay]

还是没检查出来

[hookee]

Response.Write college_pro2_constr3 输出的sql语句拷贝到数据库环境下查询看看对不对

[cyljay]

晕，忘记加数据了。
唉~~~~太低级的错误，谢谢大家了。