Profile

e-Catalog

Contact

Search

Cart

Microsoft Visual Basic 6.0 Distributed: Middle-Tier Data Access

Audience

Visual Basic enterprise developers

Prerequisites

The Microsoft Visual Basic 6.0 Desktop curriculum; advanced Microsoft Visual Basic 6.0 programming skills; an understanding of the essentials of database development

Course Aim

To outline methods and techniques for accessing data from middle-tier components using the ADO model

Learning Objectives

Access and manipulate data using the Execute Direct and Prepare/Execute models. Use different cursor locations and types to access and manipulate data. Handle database errors using the ADO Errors collection. Use appropriate locking strategies to ensure data integrity.

Topics Covered

Data access and ADO - Universal Data Access and ADO - ADO Connection and Command objects - Hands-on: Using the Connection and Command objects - Recordset updates from the middle tier - Handling errors Using ADO cursors - Introduction to cursors - Choosing cursor location and type - Hands-on: Choosing cursor types ADO and multiuser considerations - Locking strategies - Using disconnected recordsets ADO and stored procedures - Executing stored procedures - Return codes and output parameters - Hands-on: Executing a stored procedure