ADOX Troubles

ADOX Troubles

Post by Rob L'Estrang » Wed, 14 Jun 2000 04:00:00



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

 
 
 

ADOX Troubles

Post by Joe Spanice » Fri, 16 Jun 2000 04:00:00


Hi,

The error explains the problem, the database provider ADOX uses
to connect to your database can not perform this operation.
There is nothing you can do about it.

Cheers
Joe


> 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


 
 
 

1. Trouble getting Groups/Users from ADOX

Hi,

I'm working on a secured Access 2000 database and need to get the user/group
information for the Web interface I'm building. Unfortunately I can't use
... Driver={Microsoft Access Driver (*.mdb)} ... in the ConnectionString
because the default PROVIDER (ie. MSDASQL.1) does not support the
Users/Groups properties of the ADOX.Category object.

It seems I need to use the provider MICROSOFT.JET.OLEDB.4.0, however I just
can't seem to connect to the database using it, however I try it.

Does anyone know how I can extract Group/User information from the database?

When you say "you can't seem to connect" what does that mean? What is the error?
Here is a sample connection string:

Dim cat As New ADOX.Catalog

cat.ActiveConnection = _
   "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\My Documents\db1.mdb;"
& _
   "Jet OLEDB:Engine Type=4"

Additional info concerning password protected Access database files:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q191754


Microsoft MVP (Visual Basic)

2. easy question

3. Trouble appending multiple ADOX Views

4. Using rsh on Solaris to start Ingres

5. Trouble getting Groups/Users from ADOX

6. BO and Express: limit to DB size?

7. Trouble appending multiple ADOX Views

8. pw5.0, "can not modify this table" ?????

9. Trouble creating a primary key in jet via ADOX

10. Trouble getting Groups/Users from ADOX

11. Trouble using ADOX in VC6 via #import statement

12. ADOX.Indexes/ADOX.Key/Foreign Keys

13. trouble restoring a DB, trouble deleting half-restored DB