SQL Server 2005 Á¬½Ó×Ö·û´®

Ô­ÎÄת×Ô http://blog.csdn.net/jyh_jack/archive/2008/04/07/2257512.aspx
SQL Native Client ODBC Driver
 
±ê×¼°²È«Á¬½Ó
   
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
 
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express£¿ ÇëÔÚ“Server”Ñ¡ÏîʹÓÃÁ¬½Ó±í´ïʽ“Ö÷»úÃû³Æ\SQLEXPRESS”¡£ 
  
ÊÜÐŵÄÁ¬½Ó
   
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;
 
"Integrated Security=SSPI" Óë "Trusted_Connection=yes" ÊÇÏàͬµÄ¡£
  
Á¬½Óµ½Ò»¸öSQL ServerʵÀý
Ö¸¶¨·þÎñÆ÷ʵÀýµÄ±í´ïʽºÍÆäËûSQL ServerµÄÁ¬½Ó×Ö·û´®Ïàͬ¡£  
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;
 
   
Ö¸¶¨Óû§ÃûºÍÃÜÂë
oConn.Properties("Prompt") = adPromptAlways
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
 
   
ʹÓÃMARS (multiple active result sets)
   
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;MARS_Connection=yes;
 
"MultipleActiveResultSets=true"ÓëMARS_Connection=yes"ÊÇÏàͬµÄ¡£
ʹÓÃADO.NET 2.0×÷ΪMARSµÄÄ£¿é¡£ MARS²»Ö§³ÖADO.NET 1.0ºÍADO.NET 1.1¡£
  
ÑéÖ¤ÍøÂçÊý¾Ý
   
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;Encrypt=yes;
 
   
ʹÓø½¼Ó±¾µØÊý¾Ý¿âÎļþµÄ·½Ê½Á¬½Óµ½±¾µØSQL Server ExpressʵÀý
   
Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
 
ΪºÎҪʹÓÃDatabase²ÎÊý£¿Èç¹ûͬÃûµÄÊý¾Ý¿âÒѾ­±»¸½¼Ó£¬ÄÇôSQL Server½«²»»áÖØи½¼Ó¡£ 
  
ʹÓø½¼Ó±¾µØÊý¾ÝÎļþ¼ÐÖеÄÊý¾Ý¿âÎļþµÄ·½Ê½Á¬½Óµ½±¾µØSQL Server ExpressʵÀý
   
Driver={SQL Native Client};Server=.\SQLE