Connection String to connect to SQLSrver,Oracle MSAccess

1. Oracle Database

Provider=MSDAORA.1;User ID=schema username;Password=schema password;Data Source=tns service name;Persist Security Info=False

Example : - Provider=MSDAORA.1;User ID=scott;Password=tiger;Data Source=orcl;Persist Security Info=False




2. SQL Server

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=greenply;Data Source=server name/server ip

Example : - Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=master;Data Source=ServerNode



3. MSAccess Database

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\example.mdb;Persist Security Info=False

Example : - Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database path\filename;Persist Security Info=False

4. Using Data Source Name (DSN)

Provider=MSDASQL.1;Persist Security Info=False;User ID=Database user name;Password=Database Password;Data Source=DSN Name;Initial Catalog=Database Path\Database Name

Example : - Provider=MSDASQL.1;Persist Security Info=False;User ID=ADMIN;Password=PECONS;Data Source=AccessLLH;Initial Catalog=E:\ERECB1\ERECB1