Connection String for different database

1. MSACCESS

strConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Request.ServerVariables ("APPL_PHYSICAL_PATH") & "database_path[mdb file path];User Id=;Password=;"



2. SQL

strConnectionString = "provider=sqloledb.1;initial catalog=;data source=;user id=;pasword=;"



3. Oracle

Create a DSN entry, refer the created DSN in the connection string

strConnectionString = "DSN=;user id=;password="