<% 用户要有建表的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"
%>