Establish Oracle's table with ASP

xiaoxiao2021-03-06  41

<% User has a resource role of the table.

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 (constr) set = server.createObject (" adoDb.recordset ")

SQL = "Create Table yangbc2.a10 (Name varcha2 (10) Not null, id varcha2 (10) not null" 'rsopen sql, conn' is the same as the next sentence, can be conn.execute (SQL)

'rs.close' has this error 'set = Nothing conn.close set conn = Nothing response.write "OK, Successful, YANGBC"%>

转载请注明原文地址:https://www.9cbs.com/read-60056.html

New Post(0)