ASP.NET
  Home arrow ASP.NET arrow Page 5 - The ADO Object Model
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ASP.NET

The ADO Object Model
By: Apress Publishing
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 14
    2004-11-09

    Table of Contents:
  • The ADO Object Model
  • The Main ADO Objects
  • The Other ADO Objects
  • The ADOX Object Model
  • ADOX Supported Features
  • OLE DB Providers
  • Connection Strings
  • Asynchronous Processing
  • Connection Events

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    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

    Buy the book!

    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!

    More ASP.NET Articles
    More By Apress Publishing


     

    ASP.NET ARTICLES

    - Disadvantages of the ASP.NET MVC Framework
    - Advantages of the ASP.NET MVC Approach
    - ASP.NET Web Forms Weaknesses
    - ASP.NET Web Forms Meets ASP.NET MVC
    - Source Code for Saving and Retrieving Data w...
    - Using GridView to Save and Retrieve Data wit...
    - Handling Dynamic Images in ASP.NET 3.5 AJAX ...
    - Retrieving Data with AJAX and the GridView C...
    - Playing with Images in ASP.NET 3.5 AJAX Appl...
    - Saving and Retrieving Data with AJAX
    - Enhancing PHP Via the ASP.NET AJAX Framework...
    - Enhancing PHP Programming with the ASP.NET A...
    - Classes and ASP.NET AJAX
    - Using ASP.NET AJAX
    - Building a Simple Storefront with LINQ

     
    Application Delivery: Everything You Wanted to Know, but Didn`t Know You Needed to Ask
    A comprehensive guide to examining the topics of Wide-area Data Services and app....

     
    Best Practices: Safe and Secure Hardware Asset Recovery
    Companies increasingly must meet EPA and local requirements for the disposal of ....

     
    Managing SSL Security in Multi-Server Environments
    Read this white paper to learn how to simplify management of your organization's....

     
    Open Source Security Myths
    Open Source Software (OSS) is computer software whose source code is available t....

     
    Power and Cooling Capacity Management for Data Centers
    This paper describes the principles for achieving power and cooling capacity man....

     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
    Stay green...Green IT