详解SQL连接字符串中关键字

Keyword  
  Default  
  Description  
 
Application   Name  
  N/A
  The   name   of   the   application,   or   '.NET   SQLClient   Data   Provider '   if   no   application   name   is   provided.  
 
Asynch  
  'false '  
  When   true,   enables   asynchronous   operation   support.   Recognized   values   are   true,   false,   yes,   and   no.
 
AttachDBFilename  

-or-  

extended   properties  

-or-  

Initial   File   Name  
  N/A
  The   name   of   the   primary   database   file,   including   the   full   path   name   of   an   attachable   database.   The   path   may   be   absolute   or   relative   by   using   the   DataDirectory   substitution   string.   If   DataDirectory   is   used,   the   database   file   must   exist   within   a   subdirectory   of   the   directory   pointed   to   by   the   substitution   string.

Note    
Remote   server,   HTTP,   and   UNC   path   names   are   not   supported.
 

The   database   name   must   be   specified   with   the   keyword   'database '   (or   one   of   its   aliases)   as   in   the   following:

"AttachDbFileName=|DataDirectory|/data/YourDB.mdf;integrated   security=true;database=YourDatabase "  
 
Connect   Timeout  

-or-  

Connection   Timeout  
  15  
  The   length   of   time   (in   seconds)   to   wait   for   a   connection   to   the   server   before   terminating   the   attempt   and   generating   an   error.  
 
Context   Connection
  'false '
  true   if   an   in-process   connection   to   SQL   Server   should   be   made.
 
Current   Language  
  N/A
  The   SQL   Server   Language   record   name.  
 
Data   Source  

-or-  

Server  

-or-  

Address  

-or-  

Addr  

-or-  

Network   Address  
  N/A
  The   name   or   network   address   of   the   instance   of   SQL   Server   to   which   to   connect.   The   port   number   can   be   specified   after   the   server   name:

server=tcp:servername,   portnumber  

When   specifying   a   local   instance,   always   use   (local).   To   force   a   protocol,   add   one   of   the   following   prefixes:

np:(local),   tcp:(local),   lpc:(local)  
 
Encrypt  
  'false '  
  When   true,   SQL   Server   uses   SSL   encryption   for   all   data   sent   between   the   client   and   server   if   the   server   has   a   certificate   installed.   Recognized   values   are   true,   false,   yes,   and   no.  
 
Enlist
  'false '
  true   indicates   that   the   SQL   Server   connection   pooler   automatically   enlists   the   connection   in   the   creation   thread 's   current   transaction   context.
 
Failover   Partner
  N/A
  The   name   of   the   failover   partner   server   where   database   mirroring   is   configured.

The   Failover   Partner   keyword   is   not   supported   by   .NET   Framework   version   1.0   or   1.1.
 
Initial   Catalog  

-or-  

Database  
  N/A
  The   name   of   the   database.  
 
Integrated   Security  

-or-  

Trusted_Connection  
  'false '  
  When   false,   User   ID   and   Password   are   specified   in   the   connection.   When   true,   the   current   Windows   account   credentials   are   used   for   authentication.

Recognized   values   are   true,   false,   yes,   no,   and   sspi   (strongly   recommended),   which   is   equivalent   to   true.  
 
MultipleActiveResultSets  
  'true '  
  When   true,   an   application   can   maintain   multiple   active   result   sets   (MARS).   When   false,   an   application   must   process   or   cancel   all   result   sets   from   one   batch   before   it   can   execute   any   other   batch   on   that   connection.

Recognized   values   are   true   and   false.

The   keyword   is   not   supported   by   .NET   Framework   version   1.0   or   1.1.  
 
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.  
 
Packet   Size  
  8192  
  Size   in   bytes   of   the   network   packets   used   to   communicate   with   an   instance   of   SQL   Server.  
 
Password  

-or-  

Pwd  
  N/A
  The   password   for   the   SQL   Server   account   logging   on.   Not   recommended.   To   maintain   a   high   level   of   security,   we   strongly   recommend   that   you   use   the   Integrated   Security   or   Trusted_Connection   keyword   instead.  
 
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.  
 
Replication
  'false '
  true   if   replication   is   supported   using   the   connection.  
 
TrustServerCertificate
  'false '
  When   set   to   true,   SSL   is   used   to   encrypt   the   channel   but   to   bypass   walking   the   certificate   chain   to   validate   trust.   If   the   connection   string   has   TrustServerCertificate   set   to   true   but   Encrypt   is   not   set   to   true,   the   channel   is   not   encrypted.   Recognized   values   are   true,   false,   yes,   and   no.   For   more   information,   see   "Encryption   Hierarchy "   and   "Using   Encryption   Without   Validation "   in   SQL   Server   2005   Books   Online.
 
Type   System   Version
  N/A
  A   string   value   that   indicates   the   type   system   the   application   expects.   Possible   values   are:

Type   System   Version=SQL   Server   2000;  

Type   System   Version=SQL   Server   2005;  

Type   System   Version=Latest;  

When   set   to   SQL   Server   2000,   the   SQL   Server   2000   type   system   is   used.   The   following   conversions   are   performed   when   connecting   to   a   SQL   Server   2005   instance:

XML   to   NTEXT

UDT   to   VARBINARY

VARCHAR(MAX),   NVARCHAR(MAX)   and   VARBINARY(MAX)   to   TEXT,   NEXT   and   IMAGE   respectively.

When   set   to   SQL   Server   2005,   the   SQL   Server   2005   type   system   is   used.   No   conversions   are   made   for   the   current   version   of   ADO.NET.

When   set   to   Latest,   the   latest   version   than   this   client-server   pair   can   handle   is   used.   This   will   automatically   move   forward   as   the   client   and   server   components   are   upgraded.
 
User   ID  
  N/A
  The   SQL   Server   login   account.   Not   recommended.   To   maintain   a   high   level   of   security,   we   strongly   recommend   that   you   use   the   Integrated   Security   or   Trusted_Connection   keywords   instead.  
 
User   Instance
  'false '
  A   value   that   indicates   whether   to   redirect   the   connection   from   the   default   SQL   Server   Express   instance   to   a   runtime-initiated   instance   running   under   the   account   of   the   caller.
 
Workstation   ID  
  The   local   computer   name  
  The   name   of   the   workstation   connecting   to   SQ