For a SqlClient data provider, you must provide values for the following connection settings:
- Data Source
- This is a Provider Data Source. The name of the SQL Server you want to use. If the server is local, you can usually specify
- Initial Catalog
- The name of the database you want to access.
- Integrated Security
- Set this to
True to use Windows security. It is set to
False by default. When set to
False, you must either provide values for the
User ID and
Password connection settings, or provide them in your program as part of the EXEC SQL CONNECT statement.
- When using SQL Server 2005 or later, set this to
True to allow multiple active result sets.