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"/>