Work with Connections

Supply all connection settings in a single parameter named ConnectionString that follows the documented Microsoft syntax. For details about Microsoft syntax, follow this link:

http://msdn2.microsoft.com/en-us/library/ms254499.aspx

Note: The parsing of the ConnectionString is not case sensitive.

For authentication, you can use one of the following security modes:

• Windows Integrated Security

• Windows Account

• SQL Server Authentication