资源描述：
《ado连接字符串》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、QQ：403223630社区ID：happy2禁止外传ADO.NET连接字符串说明1-SQLServer2-SQLServer20053-ACCESS,Oracle4-MySQL,Interbase,IBMDB25-Sybase,Informix,Ingres,MimerSQL,Lightbase,PostgreSQL,Paradox,DNS6-Firebird,Excel,Text,DBF/FoxPro,AS/400(iSeries),Exchange,VisualFoxPro,Pervasive,UDL1SQLServerODBC标准安全"Driver={SQLServer
2、};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;DataSourc
3、e=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"信任的连接"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"(useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000)提示输入用户名和密码oConn.Provider="sqloledb"oConn.Properties("Prompt")
4、=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))SqlCon
5、nection(.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=Aro
6、n1;Database=pubs;Trusted_Connection=True;"(bothconnectionstringsproducesthesameresult)(useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000)IP地址连接管道"DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"(DBM
7、SSOCN=TCP/IPinsteadofNamedPipes,attheendoftheDataSourceistheporttouse(1433isthedefault))定义SqlConnection对象C#:usingSystem.Data.SqlClient;SqlConnectionoSQLConn=newSqlConnection();11QQ：403223630社区ID：happy2QQ：403223630社区ID：happy2禁止外传oSQLConn.ConnectionS
