数据库连接字符串大全
作者:Webmaster 来源:Linuxdby.com 点击:
日期:2007-06-03
[收藏] [投稿]
|
|
| Enlist |
'true' |
When true, the pooler automatically enlists the connection in the creation thread's current transaction context. |
Initial Catalog
-or-
Database |
|
The name of the database. |
Integrated Security
-or-
Trusted_Connection |
'false' |
Whether the connection is to be a secure connection or not. Recognized values are 'true', 'false', and 'sspi', which is equivalent to 'true'. |
| Max Pool Size |
100 |
The maximum number of connections allowed in the pool. |
| Min Pool Size |
0 |
The minimum number of connections allowed in the pool. |
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), dbmsipcn (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. |
| Packet Size |
8192 |
Size in bytes of the network packets used to communicate with an instance of SQL Server. |
Password
-or-
Pwd |
|
The password for the SQL Server account logging on. |
| Persist Security Info |
'false' |
When set to 'false', 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. |
| Pooling |
'true' |
When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. |
| User ID |
|
The SQL Server login account. |
| Workstation ID |
the local computer name |
The name of the workstation connecting to SQL Server. |
设为主页
收藏本站
相关文章:
