it:ad:connectionstrings:home

IT:AD:ConnectionStrings

  • 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)
<add name="myConnectionName_SqlServerCE"
     connectionString="Data Source=|DataDirectory|\XActiSight.sdf"
     providerName="System.Data.SqlServerCe.3.5"/>
<add name="myConnectionName_Sqlite" 
     connectionString="data source=|DataDirectory|testiSight.db"
     providerName="System.Data.SQLite"/>