We can use connection object class to establish connection to the specified
DB during runtime

set ConObj=CreateObject("ADODB.Connection")

ConObj.Open"Provider = Provider Name"

For MS-Access the provider name is

ConObj.Open"Provider = Microsoft.Jet,OLEDB.4.0; dataSource = Path of the
DataBase"

For Oracle SQL Server the Provider name is

ConObj.Open"Provider = sqloledb.1;Server=IP Address;uid=username;pwd=****;DataBase=path
of the database"

For Oracle the Provider Name is

ConObj.Open"Provider = oraoledb.1;Server=****;userid=username(Scott);password=****(tiger)"