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 &nbs