| Provider Name | connection string |
| (SQL Native Client 11.0 ODBC Driver) | Driver={SQL Server Native Client 11.0};Server=servername;Database=dbname;Trusted_Connection=yes; |
| (Microsoft OLE DB Provider for SQL Server) | Provider=SQLOLEDB.1;Data Source=servername\\instancename;Initial Catalog=dbname;Integrated Security=SSPI |
| (SQL Native Client 11.0) | Provider=SQLNCLI11;Integrated Security=SSPI;Initial Catalog=dbname;Data Source=servername\\instancename; |
| (Microsoft OLE DB Provider for ODBC Drivers) | Provider=MSDASQL.1;Persist Security Info=False;Data Source=DSN;DATABASE=dbname;ServerSPN=servername; |
Connection String Keywords with SQL Server Native Client |
|
ODBC Driver Connection String Keywords |
|
| Driver | The keyword value for the SQL Server Native Client ODBC driver is "{SQL Server Native Client 11.0}" |
| DSN | Name of an existing ODBC user or system data source. This keyword overrides any values that might be specified in the Server, Network, and Address keywords. |
| Server |
The name of a SQL Server instance. The value must be either the name of a server on the network, an IP address, or the name of a SQL Server Configuration Manager alias. The Address keyword overrides the Server keyword. |
| Trusted_Connection | When "yes", instructs the SQL Server Native Client ODBC driver to use Windows Authentication Mode for login validation. Otherwise instructs the SQL Server Native Client ODBC driver to use a SQL Server username and password for login validation, and the UID and PWD keywords must be specified |
| UID | A valid SQL Server login account. UID need not be specified when using Windows Authentication. |
OLE DB Provider Connection String Keywords |
|
| Database | The database name |
| Integrated Security | Accepts the value "SSPI" for Windows Authentication. |
| Password | The SQL Server login password |
| Provider | For SQL Server Native Client, this should be "SQLNCLI11" |
| for detail goto link http://msdn.microsoft.com/en-us/library/ms130822.aspx | |