In this article we shall learn how to connect to several databases using Microsoft visual studio or VB .NET. We shall practice the simplest code to connect to each database one by one. 

1. MS Access Database:

Dim con As New OleDb.OleDbConnection

'Dim conString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\SHANKAR\Documents\Employee.accdb;User Id=admin;Password=shanky;"

Dim conString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\SHANKAR\Documents\Employee.accdb;User Id=admin;Password=;"

        &nb ... Read more »