The ADO Object Model - ADOX Supported Features (Page 5 of 9 ) ADOX is not supported by all providers, including those supplied by Microsoft. Currently, only the OLE DB Provider for Microsoft Jet fully supports ADOX. For the other Microsoft OLE DB providers, all features are supported except for those listed here: Microsoft OLE DB Provider for SQL Server
| Object/Collection | Feature Not Supported | | Catalog Object | Create method | | Tables Collection | Properties for existing tables are read-only (properties for new tables can be read/write) | | Views Collection | Not supported | | Procedures Collection | Append method, Delete method, Command property | | Keys Collection | Append method, Delete method | | Users Collection | Not supported | | Groups Collection | Not supported | Microsoft OLE DB Provider for ODBC
| Object/Collection | Feature Not Supported | Catalog Object | Create method | Tables Collection | Append method, Delete method; Properties for existing tables are read-only (properties for new tables can be read/write) | Views Collection | Append method, Delete method, Command property | Procedures Collection | Append method, Delete method, Command property | Indexes Collection | Append method, Delete method | Keys Collection | Append method, Delete method | Users Collection | Not supported | Groups Collection | Not supported | Microsoft OLE DB Provider for Oracle
| Object/Collection | Feature Not Supported | | Catalog Object | Create method. | | Tables Collection | Append method, Delete method; Properties for existing tables are read-only (properties for new tables can be read/write) | | Views Collection | Append method, Delete method, Command property | | Procedures Collection | Append method, Delete method, Command property | | Indexes Collection | Append method, Delete method | | Keys Collection | Append method, Delete method | | Users Collection | Not supported | | Groups Collection | Not supported |  | This chapter is from ADO Programmer's Referencep,by David Sussman. (Apress Books, 2004, ISBN: 1590593421). Check it out at your favorite bookstore today. Buy this book now! |
Next: OLE DB Providers >>
More ASP.NET Articles
More By Apress Publishing |
/ 14 
