ADO.NET连接数据库字符串大全说明HYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext2#ext2"1-SQLServerHYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext3#ext3"2-SQLServer2005HYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext4#ext4"3-ACCESS,OracleHYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext5#ext5"4-MySQL,Interbase,IBMDB2HYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext6#ext6"5-Sybase,Informix,Ingres,MimerSQL,Lightbase,PostgreSQL,Paradox,DNSHYPERLINK"http://www.tiantiansoft.com/bbs/card/card.asp?fid=6137"\l"ext7#ext7"6-Firebird,Excel,Text,DBF/FoxPro,AS/400(iSeries),Exchange,VisualFoxPro,Pervasive,UDL1SQLServerODBC标准安全"Driver={SQLServer};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"信任的连接"Driver={SQLServer};Server=Aron1;Database=pubs;Trusted_Connection=yes;"提示输入用户名和密码oConn.Properties("Prompt")=adPromptAlwaysoConn.Open"Driver={SQLServer};Server=Aron1;DataBase=pubs;"OLEDB,OleDbConnection(.NET)标准安全"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"信任的连接"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"(useserverName\instanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000)提示输入用户名和密码oConn.Provider="sqloledb"oConn.Properties("Prompt")=adPromptAlwaysoConn.Open"DataSource=Aron1;InitialCatalog=pubs;"IP地址连接管道"Provider=sqloledb;DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"(DBMSSOCN=TCP/IPinsteadofNamedPipes,attheendoftheDataSourceistheporttouse(1433isthedefault))SqlConnection(.NET)标准安全"DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"-or-"Server=Aron1;Database=pubs;UserID=sa;Password=asdasd;Trusted_Connection=False"(bothconnectionstringsproducesthesameresult)信任的连接"DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"-or-"Server=Aron1;Database=pubs;Trusted_Connection=True;"(bothconnectionstringsproduces