Sideway
output.to from Sideway
Draft for Information Only

Content

ASP Server Components
  ActiveX Data Objects Component
    File Name
    Syntax
    Parameters
    Remark
   Objects & Collections of ADO Component
   Objects & Collections of ADO Component

ASP Server Components

The ASP built-in server components are provided to enhance the usability of ASP technology by adding some built-in components to increase the fundamental capability of ASP technology for creating dynamic and interactive web pages. The two basic built-in server components of ASP technology are the FileSystemObject component and the ActiveX Data Object (ADO) component. The FileSystemObject component is used to manipulate the file system of the server while the ActiveX date Object component  is designed for the database manipulation.

ActiveX Data Objects Component

The ActiveX Data Objects, ADO, is one of the key component of the Microsoft/Windows Data Access Components , MDAC/WDAC, for connecting to different data sources. The ActiveX Data Objects, ADO, provide language-neutral object base features for web-based applications to access and manipultate data from a variety of sources through the OLE DB system interfaces. The parent library of ActiveX Data Objects ADO is the  ADODB Library

In general, the five major functions of the ActiveX Data Objects, ADO component is DataBase Connection, DataBase Command, Data Recordset, and Data Record, Data Stream manipulation.

File Name

The ActiveX Data Objects component is included in the ADODB library of Microsoft Data Access Components, MDAC package.

Syntax

Set ADOName = Server.CreateObject("ADODB.IDname")

Parameters

ADOName

The parameter "ADOName" is the name assigned to the instance of the ADO object of the ADODB Library created by the call using the Server.CreateObject.

IDname

The parameter "IDname" is used to specified the name of the type of ADO DataBase object included in the ADODB Library.

Remark

Although an instance of the Connection object of the ADODB Library has higher hierarchical relationship with other ADO objects in the ADODB Library, ADO objects can also be created outside the scope of the ADO hierarchy.

Objects & Collections of ADO Component

The ActiveX Data Object, ADO of the ADODB Library component can be used in the ASP page to manipulate the data of the web server. The two major types of the data manipulation are supported by the ActiveX Data Objects, ADO component. For example, Database manipulation, including database querying, and data manipulating and displaying, Data stream and file manipulation, such as Saving data into an XML file, binary or XML stream, or retrieving an Data stream.

The ActiveX Data Object, ADO of the ADODB Library component consists of a number of objects and collections.

Summary of objects and collection of thep ADODB component is:

Name Type Description
Connection Object An Connection object instance is used to represent a unique session with a data source or an actual network connection to server in a client/server database system.
Command Object An Command object is used to define a specific command for manipulating a data source.
Recordset Object An Recordset object instance is used to represent the entire set of records from a database table query or results of an executed command.
Record Object A Record object instance is used to represent a single row data entity.
Field Object A Field object instance is used to represent a column of data corresponding to a field column in the Recordset.
Fields Collection A Collection of all Field objects of a Recordset or Record object
Parameter Object A Parameter object is used to represent a parameter or argument that associated with a Command object
Parameters Collection A Collection of all Parameter objects of a Command object.
Property Object A Property object is used to represent a characteristic of an ADO object defined by the provider. The Built-in properties are properties defined in ADODB library while the dynamic properties are properties defined by the underlying provider of the ADO object
Properties Collection A Collection of all Property objects for a specific instance of an object.
Error Object A Error object is used to contain details about data access error that pertain to a single operation involving the provider.
Errors Collection A Collection of all Error objects that is created in response to a single provider-related failure.
Stream Object A Stream object is used to represent a stream of binary or text data for further  manipulating.

Objects & Collections of ADO Component

The FileSystemObject, FSO Component consists objects or collections which are the ActiveXObject objects provided by the Microsoft Scripting Run-time for creating ASP pages. And the interactive web application can then be built through the using of these built-in objects in the web pages.sing of these built-in objects in the web pages.

Methods, Properties, Collections and Events of built-in ASP objects.

Parent & Child Relation
Built-in Objects Connection Command Recordset Record Field Parameter Property Error Stream
Methods BeginTrans Cancel AddNew Cancel AppendChunk AppendChunk     Cancel
Cancel CreateParameter Cancel Close GetChunk Delete     Close
Close Execute CancelBatch CopyRecord         CopyTo
CommitTrans CancelUpdate DeleteRecord         Flush
Execute Clone GetChildren         LoadFromFile
Open Close MoveRecord         Open
OpenSchema CompareBookmarks Open         Read
RollbackTrans Delete         ReadText
  Find         SaveToFile
  GetRows       SetEOS
  GetString       SkipLine
  Move       Write
  MoveFirst       WriteText
  MoveLast        
  MoveNext        
  MovePrevious        
  NextRecordset        
  Open        
  Requery        
  Resync        
  Save        
  Seek        
  Supports        
  Update        
  UpdateBatch        
Properties Attributes ActiveConnection AbsolutePage ActiveConnection ActualSize Attributes Attributes Description CharSet
CommandTimeout CommandText AbsolutePosition Mode Attributes Direction Name HelpContext EOS
ConnectionString CommandTimeout ActiveCommand ParentURL DefinedSize Name Type HelpFile LineSeparator
ConnectionTimeout CommandType ActiveConnection RecordType Name NumericScale Value NativeError Mode
CursorLocation Name BOF Source NumericScale Precision Number Position
DefaultDatabase Prepared Bookmark State OriginalValue Size Source Size
IsolationLevel State CacheSize   Precision Type SQLState State
Mode   CursorLocation   Status Value Type
Provider   CursorType   Type
State   DataMember   UnderlyingValue
Version   DataSource   Value
    EditMode  
    EOF  
    Filter  
    Index  
    LockType  
    MarshalOptions  
    MaxRecords  
    PageCount  
    PageSize  
    RecordCount  
    Sort  
    Source  
    State  
    Status  
    StayInSync  
       
Collections Errors Parameters Fields Fields Properties        
Properties Properties Properties Properties
Events
©sideway

ID: 130500015 Last Updated: 5/15/2013 Revision: 0 Ref:

close

References

  1. Active Server Pages,  , http://msdn.microsoft.com/en-us/library/aa286483.aspx
  2. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
  3. ASP Best Practices,  , http://technet.microsoft.com/en-us/library/cc939157.aspx
  4. ASP Built-in Objects,  , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
  5. Response Object,  , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
  6. Request Object,  , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
  7. Server Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
  8. Application Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
  9. Session Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
  10. ASPError Object,  , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
  11. ObjectContext Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
  12. Debugging Global.asa Files,  , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
  13. How to: Debug Global.asa files,  , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
  14. Calling COM Components from ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
  15. IIS ASP Scripting Reference,  , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
  16. ASP Keywords,  , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
  17. Creating Simple ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
  18. Including Files in ASP Applications,  , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
  19. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
  20. FileSystemObject Object,  , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
  21. http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx,  , ADO Object Model
  22. ADO Fundamentals,  , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx
close
Latest Updated LinksValid XHTML 1.0 Transitional Valid CSS!Nu Html Checker Firefox53 Chromena IExplorerna
 IMAGE

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 8

Culture

Chinese 1097

English 339

Reference 79

Computer

Hardware 249

Software

Application 213

Digitization 32

Latex 52

Manim 205

KB 1

Numeric 19

Programming

Web 289

Unicode 504

HTML 66

CSS 65

SVG 46

ASP.NET 270

OS 429

DeskTop 7

Python 72

Knowledge

Mathematics

Formulas 8

Algebra 84

Number Theory 206

Trigonometry 31

Geometry 34

Coordinate Geometry 2

Calculus 67

Complex Analysis 21

Engineering

Tables 8

Mechanical

Mechanics 1

Rigid Bodies

Statics 92

Dynamics 37

Fluid 5

Fluid Kinematics 5

Control

Process Control 1

Acoustics 19

FiniteElement 2

Natural Sciences

Matter 1

Electric 27

Biology 1

Geography 1

Copyright © 2000-2024 Sideway . All rights reserved Disclaimers last modified on 06 September 2019