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

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=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
ΪºÎҪʹÓÃDatabase²ÎÊýÈç¹ûͬÃûµÄÊý¾Ý¿âÒѾ­±»¸½¼Ó£¬ÄÇôSQL Server½«²»»áÖØи½¼Ó¡£
Êý¾Ý¿â¾µÏñ
Data Source=myServerAddress;Failover Partner=myMirrorServer;Initial Catalog=myDataBase;Integrated Security=True;
SQL Native Client OLE DB Provider
±ê×¼Á¬½Ó
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBas