%META:TOPICPARENT{name="InstallConfigADONETProviders"}%

=Connect String Attributes for the 100% Managed Single-Tier ADO.NET Data Provider for Microsoft SQL Server (OpenLink.Data.SQLServer)=

The tables below provides a list of the Connect String Attributes for the Data Provider:

Table: 6.3.2.1. Connection String Keywords for the Microsoft SQLServer .Net Provider 

|**Keyword**| 	**Default Value**|
|Used ID or UID| 	[""]|
|Password or PWD| 	[""]|
|Initial Catalog or DATABASE| 	[""]|
|Connect Timeout or Connection Timeout| 	[15]|
|Persist Security Info| 	[False]|
|Connection Lifetime |	[0]|
|Min Pool Size| 	[0]|
|Max Pool Size| 	[100]|
|Persist Security Info| 	[False]|
|Pooling| 	[True]|
|Charset| 	["]|
|Host| 	[localhost]|
|Port |	[1433]|
|<nop>Packet Size or <nop>PktSize| 	[8192] for SQLServer7/2000|
|<nop>SrvName or Server or Server Name| 	[""]|
|Server Type or <nop>ServerType or SVT| 	["SQLSERVER6"]|
|<nop>WorkstationId or Workstation Id| 	["localhost]|
|UNICODE| 	[False]|
|APPLICATION| 	["opldotNET"]|
|<nop>UseBrowseMode| 	["false"]|

The following Keyword default values change for the <nop>SQLServer Provider :

{{{ 
	UseBrowseMode=false - the SQLParser is used for parsing Select queries and getting the accurate information
	for following schema table columns (returned by IDataReader.GetSchemaTable).

	UseBrowseMode=true -  the "SET no_browsetable ON" comand is used with Select queries for getting the names
	and for accurate information for following schema table columns (returned by IDataReader.GetSchemaTable).
               
         Note that the MS SQLServer ADO.NET provider uses the "SET no_browsetable ON" mode. 

	The property SVT or ServerType supports the following values:

	"SQLServer 7" or "SQLServer7" (TDS7 protocol is used) 
	"SQLServer 2000" or "SQLServer2000" (TDS8 protocol is used) 
	"SQLServer 6"  or "SQLServer 6.x"  or "SQLServer"  or "SQLServer6"(TDS4.2 protocol is used) 
	
	Any another values (TDS4.2 protocol is used)
	
	Sample connection string:

		"SVT=SQLServer 2000;DATABASE=Northwind;Host=localhost;Port=1433UID=sa;PWD=;

	}}}