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
%>