asp连mysql数据插入问题

我是新手，试了个ASP连接Mysql数据库，好不容易连上了，但数据怎么都插不进去。请高手帮我看看：
<%
set conn = server.createobject("adodb.connection")
conn.open "driver={MySQL ODBC 3.51 Driver};server=localhost;
           port=3306;database=buy135com;user=buy135com;
     password=MingTian1107;stmt=set names gbk"
 set rs=server.CreateObject("adodb.recordset")
 rs.ActiveConnection=adoConn
 rs.LockType=adLockOptimistic
 rs.Open "select * from weiku"
 rs.addnew

  rs("produce")="1"
  rs("ordertype")="2"
  rs("username")="3"
  rs("phonenumber")="4"
  rs("payway")="5"
  rs("leavewords")="6"
  rs("orderaddress")="7"
  rs("ordertime")="8"
  rs("url")="9"
  
  rs.Update

  rs.Close
  set rs=nothing
  conn.close
  set conn=nothing
%>