Probably the most familiar data provider is the SQL Server database provider, so Table 39-1 details some of the common connection properties you may need to specify to connect to your database server.
Each connection string property must be specified as it appears in the preceding table, but they can be in any order in the connection string. A semicolon is used to separate each property. An example connection string might be as follows:
Data Source=drnick;Initial Catalog=AdventureWorks;Integrated Security=True; MultipleActiveResultSets=True
3.145.45.5