Creating a Connection object

Creating a Connection object in Visual Basic
The Connection object establishes a connection to a data source. It allows your application to pass client information, such as username and password to the database for validation.
Steps:

Set a reference to the ADO Object Library.
Declare a Connection object
Specify an OLE DB data provider
Pass connection information

Set a reference to the [...]