IT:AD:ConnectionStrings

Summary

Notes

Sql Server

  • Classic Connection Strings:
    • Data Source=(local);Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
    • Data Source=(local);Initial Catalog=myDataBase;Integrated Security=SSPI;
    • Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;

    ##### Regarding SqlServer DataSources #####

DataSources in SqlServer connection strings can be of the following type:

  • (local)
  • (localhost)
  • . which is same as (local)

Sql Server CE

<add name="myConnectionName_SqlServerCE"
     connectionString="Data Source=|DataDirectory|\XActiSight.sdf"
     providerName="System.Data.SqlServerCe.3.5"/>

Sqlite

<add name="myConnectionName_Sqlite" 
     connectionString="data source=|DataDirectory|testiSight.db"
     providerName="System.Data.SQLite"/>