Dear All,
I am having troubles with creating database tables using ADOX. When I
attempt to run an ASP script to create a table, I get this message:
ADOX.Tables error '800a0cb3'
Object or provider is not capable of performing requested operation.
/yesresources/sections/programmer/Steve/StevesTestScript.asp, line 116
I am logged on as the dbo (database owner), and it still refuses this
append. The line is:
"cat.Tables.Append tbl"
Here is a snippet of the code in my script:
Dim tbl
Dim cat
Set tbl = Server.CreateObject("ADOX.Table")
Set cat = Server.CreateObject("ADOX.Catalog")
cat.ActiveConnection = "DSN=yrTest;uid=myusername;" _
& "pwd=mypassword"
tbl.Name = "MyTable"
tbl.Columns.Append "Id", adInteger
'tbl.Columns("Id").Properties("AutoIncrement") = True
tbl.Columns.Append "Column2", adInteger
tbl.Columns.Append "Column3", adInteger
cat.Tables.Refresh
cat.Tables.Append tbl
ReleaseObject cat
ReleaseObject tbl
If anyone has any idea on what's going on I would be MOST greatful :)
Steve