How to create database table with ASP

How to create database table with ASP

To create database table with ASP

To create the database table with ASP, you need to do as followed.

<%

set conn=Server.CreateObject("ADODB.Connection")

conn.Open "DSN=tenderproject;UID=tenderproject;PWD=tender"

set rs=Server.CreateObject("ADODB.Recordset")

sqlstr = "CREATE TABLE mytbl ( userid int, name varchar(30))"

rs.open sqlstr, conn, 1,3

%>