减小字体
增大字体- ·上一篇文章：将图片插入数据库并使用asp.net读取出来的正确方法(1)
- ·下一篇文章：Asp.net中创建和使用Ado.net（一）
Asp.net中创建和使用Ado.net（二）
edentials are used for authentication.
Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.
集成安全性
- 或 -
Trusted_Connection
'false'
当为 false 时，将在连接中指定用户 ID 和密码。当为 true 时，将使用当前的 Windows 帐户凭据进行身份验证。
可识别的值为 true、false、yes、no 以及与 true 等效的 sspi（强烈推荐）。
Network Library
-or-
Net
'dbmssocn'
The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmslpcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).
The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.
网络库
- 或 -
网络
'dbmssocn'
用于建立与 SQL Server 实例的连接的网络库。支持的值包括 dbnmpntw（命名管道）、dbmsrpcn（多协议）、dbmsadsn (Apple Talk)、dbmsgnet (VIA)、dbmslpcn（共享内存）及 dbmsspxn (IPX/SPX) 和 dbmssocn (TCP/IP)。
相应的网络 DLL 必须安装在要连接的系统上。如果不指定网络而使用一个本地服务器（比如“.”或“(local)”），则使用共享内存。
Packet Size
8192
Size in bytes of the network packets used to communicate with an instance of SQL Server.
数据包大小
8192
用来与 SQL Server 的实例进行通讯的网络数据包的大小，以字节为单位。
Password
-or-
Pwd
The password for the SQL Server account logging on (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security or Trusted_Connection keyword instead.).
密码
- 或 -
Pwd
SQL Server 帐户登录的密码（建议不要使用。为了维护最高级别的安全性，强烈建议改用 Integrated Security 或 Trusted_Connection 关键字）。
Persist Security Info
'false'
When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password. Recognized values are true, false, yes, and no.
持续安全信息
'false'
当该值设置为 false 或 no（强烈推荐）时，如果连接是打开的或者一直处于打开状态，那么安全敏感信息（如密码）将不会作为连接的一部分返回。重置连接字符串将重置包括密码在内的所有连接字符串值。可识别的值为 true、false、yes 和 no。
User ID
The SQL Server login account (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security or Trusted_Connection keyword instead.).
用户 ID
SQL Server 登录帐户（建议不要使用。为了维护最高级别的安全性，强烈建议改用 Integrated Security 或 Trusted_Connection 关键字）。
Workstation ID
the local computer name
The name of the workstation connecting to SQL Server.
工作站 ID
本地计算机名称
连接到 SQL Server 的工作站的名称。
Name
Default
Description
名称
默认值
说明
Connection Lifetime
0
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online.
A value of zero (0) causes pooled connections to have the maximum connection timeout.
连接生存期
0
当连接被返回到池时，将其创建时间与当前时间作比较，如果时间长度（以秒为单位）超出了由 Connection Lifetime 指定的值，该连接就会被销毁。这在聚集配置中很有用（用于强制执行运行中的服务器和刚置于联机状态的服务器之间的负载平衡）。
零 (0) 值将使池连接具有最大的连接超时。
Connection Reset
'true'
Determines whether the database connection is reset when being drawn from the pool. For Microsoft SQL Server version 7.0, setting to false avoids making an additional server round trip when obtaining a connection, but you must be aware that the connection state, such as database context, is not being reset.
连接重置
'true'
确定从池中提取数据库连接时是否重置数据库连接。对于 Microsoft SQL Server 7.0 版，设置为 false 可避免获取连接时再有一次额外的服务器往返行程，但须注意此时并未重置连接状态（如数据库上下文）。
Enlist
'true'
When true, the pooler automatically enlists the connection in the creation thread's current transaction context. Recognized values are true, false, yes, and no.
登记
'true'
当该值为 true 时，池程序在创建线程的当前事务上下文中自动登记连接。可识别的值为 true、false、yes 和 no。
Max Pool Size
100
The maximum number of connections allowed in the pool.
最大池大小
100
池中允许的最大连接数。
Min Pool Size
0
The minimum number of connections allowed in the pool.
最小池大小
0
池中允许的最小连接数。
Pooling
'true'
When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Recognized values are true, false, yes, and no.
池
'true'
当该值为 true 时，系统将从相应池中提取 SQLConnection 对象，或在必要时创建该对象并将其添加到相应池中。可识别的值为 true、false、yes 和 no。
做人要厚道，请注明转自chinazhan中国站长(www.ChinaZhan.com)。
Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.
集成安全性
- 或 -
Trusted_Connection
'false'
当为 false 时，将在连接中指定用户 ID 和密码。当为 true 时，将使用当前的 Windows 帐户凭据进行身份验证。
可识别的值为 true、false、yes、no 以及与 true 等效的 sspi（强烈推荐）。
Network Library
-or-
Net
'dbmssocn'
The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmslpcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).
The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.
网络库
- 或 -
网络
'dbmssocn'
用于建立与 SQL Server 实例的连接的网络库。支持的值包括 dbnmpntw（命名管道）、dbmsrpcn（多协议）、dbmsadsn (Apple Talk)、dbmsgnet (VIA)、dbmslpcn（共享内存）及 dbmsspxn (IPX/SPX) 和 dbmssocn (TCP/IP)。
相应的网络 DLL 必须安装在要连接的系统上。如果不指定网络而使用一个本地服务器（比如“.”或“(local)”），则使用共享内存。
Packet Size
8192
Size in bytes of the network packets used to communicate with an instance of SQL Server.
数据包大小
8192
用来与 SQL Server 的实例进行通讯的网络数据包的大小，以字节为单位。
Password
-or-
Pwd
The password for the SQL Server account logging on (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security or Trusted_Connection keyword instead.).
密码
- 或 -
Pwd
SQL Server 帐户登录的密码（建议不要使用。为了维护最高级别的安全性，强烈建议改用 Integrated Security 或 Trusted_Connection 关键字）。
Persist Security Info
'false'
When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password. Recognized values are true, false, yes, and no.
持续安全信息
'false'
当该值设置为 false 或 no（强烈推荐）时，如果连接是打开的或者一直处于打开状态，那么安全敏感信息（如密码）将不会作为连接的一部分返回。重置连接字符串将重置包括密码在内的所有连接字符串值。可识别的值为 true、false、yes 和 no。
User ID
The SQL Server login account (Not recommended. To maintain a high level of security, it is strongly recommended that you use the Integrated Security or Trusted_Connection keyword instead.).
用户 ID
SQL Server 登录帐户（建议不要使用。为了维护最高级别的安全性，强烈建议改用 Integrated Security 或 Trusted_Connection 关键字）。
Workstation ID
the local computer name
The name of the workstation connecting to SQL Server.
工作站 ID
本地计算机名称
连接到 SQL Server 的工作站的名称。
Name
Default
Description
名称
默认值
说明
Connection Lifetime
0
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online.
A value of zero (0) causes pooled connections to have the maximum connection timeout.
连接生存期
0
当连接被返回到池时，将其创建时间与当前时间作比较，如果时间长度（以秒为单位）超出了由 Connection Lifetime 指定的值，该连接就会被销毁。这在聚集配置中很有用（用于强制执行运行中的服务器和刚置于联机状态的服务器之间的负载平衡）。
零 (0) 值将使池连接具有最大的连接超时。
Connection Reset
'true'
Determines whether the database connection is reset when being drawn from the pool. For Microsoft SQL Server version 7.0, setting to false avoids making an additional server round trip when obtaining a connection, but you must be aware that the connection state, such as database context, is not being reset.
连接重置
'true'
确定从池中提取数据库连接时是否重置数据库连接。对于 Microsoft SQL Server 7.0 版，设置为 false 可避免获取连接时再有一次额外的服务器往返行程，但须注意此时并未重置连接状态（如数据库上下文）。
Enlist
'true'
When true, the pooler automatically enlists the connection in the creation thread's current transaction context. Recognized values are true, false, yes, and no.
登记
'true'
当该值为 true 时，池程序在创建线程的当前事务上下文中自动登记连接。可识别的值为 true、false、yes 和 no。
Max Pool Size
100
The maximum number of connections allowed in the pool.
最大池大小
100
池中允许的最大连接数。
Min Pool Size
0
The minimum number of connections allowed in the pool.
最小池大小
0
池中允许的最小连接数。
Pooling
'true'
When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Recognized values are true, false, yes, and no.
池
'true'
当该值为 true 时，系统将从相应池中提取 SQLConnection 对象，或在必要时创建该对象并将其添加到相应池中。可识别的值为 true、false、yes 和 no。
做人要厚道，请注明转自chinazhan中国站长(www.ChinaZhan.com)。