SQL ODBC connection strings
Standard Security:
Driver={SQLServer};Server=yourServerName;Database=yourDatabaseName;Uid=yourUsername;Pwd=yourPassword;
Trusted connection:
Driver={SQLServer};Server=yourServerName;Database=yourDatabaseName;Trusted_Connection=yes;
SQL OLE DB connection strings
SQL Server 2005, 2008
System.Data.OleDb.OleDbConnection
Standard Security:
Provider=SQLOLEDB;Data Source=yourServerName;Initial Catalog=yourDatabaseName;UserId=yourUsername;Password=yourPassword;
Trusted connection:
Provider=SQLOLEDB;Data Source=yourServerName;Initial Catalog=yourDatabaseName;Integrated Security=SSPI;
SQL OleDbConnection .NET strings
Standard Security:
Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;
Trusted connection:
Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;
SQL SqlConnection .NET strings
Standard Security:
1. Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;
2. Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False
Trusted connection:
1. Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;
2. Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;