Various Connection String

All Database ConnectionString in web.config file for ASP.NET

		
		

1) ORACLE

    <add name="OracleConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=27.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=27.0.0.1)(SID=ORCLSID)));User Id=scott;Password=tiger;" providerName="Oracle.DataAccess.Client"/>
    <add name="OracleConnectionString" connectionString="Data Source=27.0.0.1:1521/orcl;User ID=sccott;Password=tiger;" providerName="Oracle.DataAccess.Client"/>

2) MSSQL

    <add name="MSSQLConnectionString" connectionString="Data Source=27.0.0.1;Initial Catalog=Northwind; User ID=sa;Password=MYPassword; Connect Timeout=0;" providerName="System.Data.SqlClient" />
    <add name="MSSQLConnectionString" connectionString="Server=270.0.01;Database=Northwind; uid=sa;pwd=MYPassword;" providerName="System.Data.SqlClient" />
    <add name="MSSQLConnectionString" connectionString="Data Source=MY-PC\SQLI; Initial Catalog=Northwind;Integrated Security=true" />

3) MYSQL
    <add name="CBSConnectionString" connectionString="Server=27.0.0.1;port=3306;Database=dbname; Uid=root;Pwd=MYPassword;" providerName="MySql.Data.MySqlClient"/>

Login for comment