Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006


    Just show me the posts

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    per MSDN, information re ADOX

    ADOX is an extension to the ADO objects and programming model. It exposes additional objects for creating, modifying, and deleting schema objects, such as tables and procedures. It also includes security objects to maintain user accounts and groups and to grant and revoke permissions on objects. However, the Microsoft OLE DB Provider for SQL Server does not support many ADOX features. The unsupported features are listed below by object or collection:

    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.
    Because ADOX is not well supported against SQL Server and MSDE databases, as an alternative you can perform a more complete set of DDL and administration programming tasks by executing Transact-SQL statements against ADO Command objects, or by using the SQL Distributed Management Objects (SQL-DMO) programming model.

    For reference information about ADOX, see C:\Program Files\Common Files\System\ado\ado210.chm.

    For information about technical issues, known bugs, and limitations of ADOX and other parts of the MDAC, see the MDAC Readme file, which by default is located at C:/Program Files/Common Files/System/ado/MDACReadme.htm.

    For reference information about using SQL-DMO, see the "Developing SQL-DMO Applications" book, which is contained in the "Building SQL Server Applications" book in SQL Server Books Online.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts