SQL链接数据库

Standard   Security:  
   
  "Data   Source=Aron1;Initial   Catalog=pubs;User   Id=sa;Password=asdasd;"    
        -   or   -  
  "Server=Aron1;Database=pubs;User   ID=sa;Password=asdasd;Trusted_Connection=False"    
        (both   connection   strings   produces   the   same   result)  
   
   
   
   
    Trusted   Connection:  
   
  "Data   Source=Aron1;Initial   Catalog=pubs;Integrated   Security=SSPI;"    
        -   or   -  
  "Server=Aron1;Database=pubs;Trusted_Connection=True;"    
        (both   connection   strings   produces   the   same   result)  
   
  (use   serverName/instanceName   as   Data   Source   to   use   an   specifik   SQLServer   instance)  
    Connect   via   an   IP   address:  
  "Data   Source=190.190.200.100,1433;Network   Library=DBMSSOCN;Initial   Catalog=pubs;User   ID=sa;Password=asdasd;"    
  (DBMSSOCN=TCP/IP   instead   of   Named   Pipes,   at   the   end   of   the   Data   Source   is   the   port   to   use   (1433   is   the   default))  
    Enabling   MARS   (multiple   active   result   sets):  
   
  "Server=Aron1;Database=pubs;Trusted_Connection=True;MultipleActiveResultSets=true"    
  Note!   Use   ADO.NET   2.0   for   MARS   functionality.   MARS   is   not   supported   in   ADO.NET   1.0   nor   ADO.NET   1.1  
   
  Streamline   your   Data   Connections   by   Moving   to   MARS,   by   Laurence   Moroney,   DevX.com   >>  
    Attach   a   database   file   on   connect   to   a   local   SQL   Server   Express   instance:  
   
  "Server=./SQLExpress;AttachDbFilename=c:/asd/qwe/mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"    
        -   or   -  
  "Server=./SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"    
        (use   |DataDirectory|   when   your   database   file   resides   in   the   data   directory)    
  Why   is   the   "Database"   parameter   needed?   Answer:   If   the   database   was   previously   attached,   SQL   Server   does   not   reattach   it   (it   uses   the   attached   database   as   the   default   for   the   connection).  
    Using   "User   Instance"   on   a   local   SQL   Server   Express   instance:  
   
  "Data   Source=./SQLExpress;integrated   security=true;attachdbfilename=|DataDirectory|/mydb.mdf;user   instance=true;"    
  The   "User   Instance"   functionality   creates   a   new   SQL   Server   instance   on   the   fly   during   connect.   This   works   only   on   a   local   SQL   Server   2005   instance   and   only   when   connecting   using   windows   authentication   over   local   named   pipes.   The   purpose   is   to   be   able   to   create   a   full   rights   SQL   Server   instance   to   a   user   with   limited   administrative   rights   on   the   computer.   To   enable   the   functionality:   sp_configure   'user   instances   enabled','1'   (0   to   disable)  
  Using   SQL   Server   2005   Express?   Don't   miss   the   server   name   syntax:   SERVERNAME/SQLEXPRESS   (Substitute   "SERVERNAME"   with   the   name   of   the   computer)