ADO Programming Considerations

When using ADO to write programs against Microsoft® SQL Server™, some common data access issues you need to address include:

• Handling data definition language.

  Usage of SQL statements that support the definition or declaration of database objects.

• Using prepared statements.

  Compiling statements that will be executed multiple times.

• Executing a stored procedure.

  Using the ADO Command object to execute a SQL Server stored procedure.

• Using return code and output parameters for stored procedures.

  Coding the different types of parameters for use with a SQL Server stored procedure.

• Using batch updating.

  Committing (or canceling) all pending changes on the client and sending them to the database at one time.

• Generating multiple recordsets.

  Writing code that handles queries where multiple result sets are generated.

• Using server cursors.

  Setting the cursor and lock type for the application.

• Using long data types.

  Handling large ntext, text and image data.