DB Connection Strings (ASP.NET)

SQL Server

SqlConnection

Standard Security

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Connect via IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.

Oracle

Oracle.DataAccess.Client.OracleConnection

Standard

Data Source=TORCL;User Id=myUsername;Password=myPassword;

Using integrated security

Data Source=TORCL;Integrated Security=SSPI;

Using ODP.NET without tnsnames.ora

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=MyHost)(PORT=MyPort))) (CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

For more connection strings, visit www.connectionstrings.com.