用ASP建立oracle的表

<% 用户要有建表的resource角色 grant resource to yangbc2;

 set conn=server.createobject("adodb.connection")

 constr="Driver={Microsoft ODBC for Oracle};Server=yang11;Uid=yangbc2;Pwd=yang9812;" 
 
 'constr="Provider=OraOLEDB.Oracle.1;Password=change_on_install;Persist Security Info=True;User ID=sys;Data Source=yang11"
 
 conn.Open(ConStr)
 
 set rs=server.createobject("adodb.recordset")

 
 sql="CREATE TABLE yangbc2.A10(name VARCHAR2(10) NOT NULL, id VARCHAR2(10) NOT NULL)"
 'rs.open sql,conn '与下一句作用相同，都可以
 conn.Execute(sql)

 'rs.close     '有这句出错
 'set rs=nothing
 
 conn.close
 set conn=nothing
 
 response.write "OK,successful,yangbc"
%>