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: 15/5/2013 Revision: 0 Ref:

close

References

  1. Active Server Pages,  
  2. ASP Overview,  
  3. ASP Best Practices,  
  4. ASP Built-in Objects,  
  5. Response Object,  
  6. Request Object,  
  7. Server Object (IIS),  
  8. Application Object (IIS),  
  9. Session Object (IIS),  
  10. ASPError Object,  
  11. ObjectContext Object (IIS),  
  12. Debugging Global.asa Files,  
  13. How to: Debug Global.asa files,  
  14. Calling COM Components from ASP Pages,  
  15. IIS ASP Scripting Reference,  
  16. ASP Keywords,  
  17. Creating Simple ASP Pages,  
  18. Including Files in ASP Applications,  
  19. ASP Overview,  
  20. FileSystemObject Object,  
  21. http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx,  
  22. ADO Fundamentals,  
close
IMAGE

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 7

Culture

Chinese 1097

English 337

Reference 67

Computer

Hardware 149

Software

Application 187

Digitization 24

Numeric 19

Programming

Web 764

CSS 1

ASP.NET 1

Regular Expression 1

HTML

Knowledge Base

Common Color 1

Html Entity (Unicode) 1

Html 401 Special 1

OS 389

MS Windows

Windows10 1

.NET Framework 1

DeskTop 7

Knowledge

Mathematics

Formulas 8

Algebra 21

Number Theory 206

Trigonometry 18

Geometry 18

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

Physics

Electric 11

Biology 1

Geography 1


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