[dba-SQLServer] ADOX help

There are limits on what can be done with ADOX with SQL Server as 
opposed to Jet through OLEDB provider.
To get around these limits use a different tool SQL-DMO or the newer one 
for SQL Express SQL-SMO

'This is what the Documentation says...


'Provider Support for ADOX
'Certain features of ADOX are unsupported, depending upon your OLE DB 
data provider. ADOX is fully supported with the OLE DB Provider for 
Microsoft Jet.
'The unsupported features with the Microsoft OLE DB Provider for SQL 
Server, the Microsoft OLE DB Provider for ODBC, or the Microsoft OLE DB 
Provider for Oracle are listed below.
'ADOX is not supported by any other Microsoft OLE DB providers.


'Microsoft OLE DB Provider for SQL Server
'Object or Collection Usage Restriction


'Catalog object                 The Create method is not supported.
'Tables collection              Properties are read/write prior to 
object creation, and read-only when referencing an existing object.
'Views collection              Views is not supported.
'Procedures collection      The Append and Delete methods are not supported.
'Procedure object            The Command property is not supported.
'Keys collection               The Append and Delete methods are not 
supported.
'Users collection              Users is not supported.
'Groups collection           Groups is not supported.



Susan Harkins wrote:

>Anybody here familiar with using ADOX and SQL Server and have some free time
>today? I need help completing an article -- all I would need is a few
>snippets of generic code -- but I need them today. Specifically, I'd like an
>example of appending a column to an existing table or appending a new table
>to a database. Also, I'd like a security example -- not as specific on it --
>could be as simple as appending a new user to an existing group. 
> 
>Susan H. 
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada