28,409
社区成员
发帖
与我相关
我的任务
分享请教高手！
我在测试时页面会出现“ADODB.Connection 错误 '800a0e79'
对象打开时，不允许操作。
/1.asp，行 40
”的现象，而我程序是“set conn1=server.createobject("ADODB.CONNECTION")
conn1.open"dsn=annuity;uid=bcck;pwd=jie0522888"
conn1.Open "insert into annuity (name,month,number,annuity)values("&name&","&number&","&mont&","&annuity&")"
set conn2=server.createobject("ADODB.RECORDSET")
”请问那位高手能给予指点！谢谢！
对象打开时，不允许操作。
/1.asp，行 40
”的现象，而我程序是“set conn1=server.createobject("ADODB.CONNECTION")
conn1.open"dsn=annuity;uid=bcck;pwd=jie0522888"
conn1.Open "insert into annuity (name,month,number,annuity)values("&name&","&number&","&mont&","&annuity&")"
set conn2=server.createobject("ADODB.RECORDSET")
”请问那位高手能给予指点！谢谢！
...全文
请发表友善的回复…
发表回复
pizixt 2004-04-03
- 打赏
- 举报
conn1.open 是建立数据库连接
conn1.execute 是执行SQL
conn1.execute 是执行SQL
bcck 2004-04-03
- 打赏
- 举报
那execute 与open 到底有什么区别呢，麻烦您简单说一下，谢谢！我刚学这东西
pizixt 2004-04-03
- 打赏
- 举报
....最后少写了个括号 )
pizixt 2004-04-03
- 打赏
- 举报
conn1.execute("insert into annuity(name,month,number,annuity) values('"&name&"',"&number&","&mont&",'"&annuity&"')"
字符型加单引号
字符型加单引号
bcck 2004-04-03
- 打赏
- 举报
怎么还有错误呢？
zorou_fatal 2004-04-02
- 打赏
- 举报
后面改成
conn1.execute "insert into annuity (name,month,number,annuity)values("&name&","&number&","&mont&","&annuity&")"
conn1.execute "insert into annuity (name,month,number,annuity)values("&name&","&number&","&mont&","&annuity&")"
