CONNECTING TO A DATABASE

1
CONNECTING TO A DATABASE
2
ASP OBJECTS

• RESPONSE
• REQUEST
• SERVER
• SESSION
• APPLICATION

3
SERVER OBJECT

• PROPERTIES
• SCRIPTIMEOUT
• COLLECTIONS
• NONE
• METHODS
• CREATEOBJECT
• HTMLENCODE
• MAPPATH
• URLENCODE
• EVENTS
• NONE

4
ACTIVEX DATA OBJECTS

• COMMAND
• CONNECTION
• ERROR
• FIELD
• PARAMETER
• PROPERTY
• RECORDSET

5
CONNECTION

• PROPERTY
• ATTRBUTES
• COMMANDTIMEOUT
• CONNECTIONSTRING
• CONNECTIONTIMEOUT
• CURSOR LOCATION
• DEFAULT DATABASE
• ISOLATIONLEVEL
• MODE
• PROVIDER
• STATE

6
CONNECTION (contd)

• COLLECTIONS
• ERRORS
• PROPERTIES
• METHODS
• BEGINTRANS
• CLOSE
• COMMITTRANS
• EXECUTE

7
CONNECTION (contd)

• METHODS (contd)
• OPEN
• OPENSCHEMA
• ROLLBACKTRANS

8
RECORDSET

• PROPERTY
• ABSOLUTEPAGE
• ABSOLUTEPOSITION
• ACTIVECONNECTION
• BOF
• BOOKMARK
• CACHESIZE

9
RECORDSET (contd)

• PROPERTY (contd)
• CURSORLOCATION
• CURSORTYPE
• EDITMODE
• EOF
• FILTER
• LOCKTYPE
• MARSHALOPTIONS

10
RECORDSET (contd)

• PROPERTY (contd)
• MAXRECORDS
• PAGESIZE
• PAGECOUNT
• RECORDCOUNT
• SOURCE
• STATE
• STATUS

11
RECORDSET (contd)

• COLLECTIONS
• FIELDS
• PROPERTIES
• METHODS
• ADDNEW
• CANCELBATCH
• CANCELUPDATE
• CLONE

12
RECORDSET (contd)

• METHODS (contd)
• CLOSE
• DELETE
• GETROWS
• MOVE
• MOVEFIRST
• MOVELAST
• MOVENEXT
• MOVEPREVIOUS

13
RECORDSET (contd)

• METHODS (contd)
• NEXTRECORDSET
• OPEN
• REQUERY
• RESYNC
• SUPPORTS
• UPDATE
• UPDATEBATCH