ADO Connection and Error Handling

ADO and SQL Server

ADO and SQL Server

ADO Connection and Error Handling

This sample application demonstrates how to use ADO to connect to and query a database in an instance of Microsoft® SQL Server™ using the Microsoft OLE DB Provider for SQL Server (SQLOLEDB). Error handling routines are also demonstrated.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ADO\VB\Intro

Running the Sample

Open the Microsoft Visual Basic® project file, Adomain.vbp, and then start the project.

Remarks

Visual Basic version 6.0 includes new data handling tools not covered in this sample, such as the ADO Data Binding Control. Features such as these allow the building of client applications with a minimum amount of code. For more information about building a basic database client using the DataGrid and ADO Data Control, see the MSDN Library at Microsoft Web site

See Also

ADO Samples