Create Table

[harrysdad]

I'm wondering if you can issue a SQL CREATE TABLE command from an asp? Any ideas?

Regards,

Tony

 

[foxbox]

Yes with a normal CREATE TABLE statement

strSQL = "CREATE TABLE MyTabel " &_
         "( field1 int, field 2 varchar (50) )"
conn.execute strSQL

But: your ASP page is probably running under user IUSR_<servername>, and this user probably does nog have rights to create tables . . .




hth,
Foxbox

 

[harrysdad]

Does that mean I would have to include a username & password in the page to give me that privilege, or would that not work?

 

[foxbox]

see this (and other) FAQ:

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=3802

hth,
Foxbox