[Asp.Net]Êý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«(ת)

SQL·þÎñÆ÷ ODBCÁ¬½Ó·½Ê½
±ê×¼°²È«Á¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÐÅÈÎÁ¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
ÌáʾÊäÈëÓû§ÃûºÍÃÜÂ뷽ʽ
Õâ¸öÓÐÒ»µãÎÊÌ⣬Ê×ÏÈÄãÐèÒªÉèÖÃÒ»¸öPrompt ÊôÐÔµÈÓÚadPromptAlwaysÁ¬½Ó¶ÔÏó£¬È»ºóÔÚʹÓÃÁ¬½Ó×Ö·û´®
oConn.Properties("Prompt") = adPromptAlways
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;
OLE DB, OleDbConnection Á¬½Ó·½Ê½(.NET)
±ê×¼°²È«Á¬½Ó
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
ÐÅÈÎÁ¬½Ó
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
Ö¸¶¨·þÎñÆ÷µÄÁ¬½Ó
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI;
ÌáʾÊäÈëÓû§ÃûºÍÃÜÂ뷽ʽ
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
Data Source=myServerAddress;Initial Catalog=myDataBase;
ͨ¹ýIPµØÖ·Á¬½Ó
ÕâÀïµÄData Source=190.190.200.100,1433 Ç°ÃæµÄ190.190.200.100ÊÇIPµØÖ·£¬1433Á¬½ÓÊǶ˿Ú
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
SqlConnectionÁ¬½Ó·½Ê½ (.NET)
±ê×¼°²È«Á¬½Ó
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
±ê×¼°²È«ÁíÍâÒ»ÖÖÁ¬½Óд·¨
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
ÐÅÈÎÁ¬½Ó
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
ÐÅÈÎÁ¬½ÓÁíÍâÒ»ÖÖÁ¬½Óд·¨
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Ö¸¶¨·þÎñÆ÷µÄÁ¬½Ó
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
¶ÔCEÉ豸µÄÐÅÈÎÁ¬½Ó
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Pa