net中各種數(shù)據(jù)庫連接大全

1、.中各種數(shù)據(jù)庫連接大全中各種數(shù)據(jù)庫連接大全2008120動(dòng)網(wǎng)先鋒SQLServerODBCStardSecurity:“Driver=SQLServerServer=Aron1Database=pubsUid=saPwd=asdasd“Trustedconnection:“Driver=SQLServerServer=Aron1Database=pubsTrusted_Connection=yes“Promptfusernamepass

2、wd:oConn.Properties(“Prompt“)=adPromptAlwaysoConn.Open“Driver=SQLServerServer=Aron1DataBase=pubs“OLEDBOleDbConnection(.)StardSecurity:“Provider=sqloledbDataSource=Aron1InitialCatalog=pubsUserId=saPasswd=asdasd“TrustedCon

3、nection:“Provider=sqloledbDataSource=Aron1InitialCatalog=pubsIntegratedSecurity=SSPI“(useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstanceonlySQLServer2000)Promptfusernamepasswd:oConn.Provider=“sqloledb“

4、oConn.Properties(“Prompt“)=adPromptAlwaysoConn.Open“DataSource=Aron1InitialCatalog=pubs“ConnectviaanIPaddress:“Provider=sqloledbDataSource=190.190.200.1001433wkLibrary=DBMSSOCNInitialCatalog=pubsUserID=saPasswd=asdasd“(D

5、BMSSOCN=TCPIPinsteadofNamedPipesattheendoftheDataSourceisthepttouse(1433isthedefault))SqlConnection(.)StardSecurity:“DataSource=Aron1InitialCatalog=pubsUserId=saPasswd=asdasd“TrustedConnection:“DataSource=Aron1InitialCat

6、alog=pubsIntegratedSecurity=SSPI“(useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstanceonlySQLServer2000)ConnectviaanIPaddress:“DataSource=190.190.200.1001433wkLibrary=DBMSSOCNInitialCatalog=pubsUserID=sa

7、Passwd=asdasd“(DBMSSOCN=TCPIPinsteadofNamedPipesattheendoftheDataSourceisthepttouse(1433isthedefault))DeclaretheSqlConnection:C#:usingSystem.Data.SqlClientSqlConnectionoSQLConn=newSqlConnection()betweenarunningserveraser

8、verjustbroughtonline.ConnectionResettrueDetermineswhetherthedatabaseconnectionisresetwhenbeingremovedfromthepool.Settingtofalseavoidsmakinganadditionalserverroundtripwhenobtainingaconnectionbuttheprogrammermustbeawaretha

9、ttheconnectionstateisnotbeingreset.CurrentLanguageTheSQLServerLanguagerecdname.DataSourceServerAddressAddrwkAddressThenamewkaddressoftheinstanceofSQLServertowhichtoconnect.EnlisttrueWhentruethepoolerautomaticallyenlistst

10、heconnectioninthecreationthreadscurrenttransactioncontext.InitialCatalogDatabaseThenameofthedatabase.IntegratedSecurityTrusted_ConnectionfalseWhethertheconnectionistobeasecureconnectionnot.Recognizedvaluesaretruefalsessp

11、iwhichisequivalenttotrue.MaxPoolSize100Themaximumnumberofconnectionsallowedinthepool.MinPoolSize0Theminimumnumberofconnectionsallowedinthepool.wkLibrarydbmssocnThewklibraryusedtoestablishaconnectiontoaninstanceofSQLServe

12、r.Supptedvaluesincludedbnmpntw(NamedPipes)dbmsrpcn(Multiprotocol)dbmsadsn(AppleTalk)dbmsg(VIA)dbmsipcn(SharedMemy)dbmsspxn(IPXSPX)dbmssocn(TCPIP).ThecrespondingwkDLLmustbeinstalledonthesystemtowhichyouconnect.Ifyoudonots

13、pecifyawkyouusealocalserver(fexample“.““(local)“)sharedmemyisused.PacketSize8192SizeinbytesofthewkpacketsusedtocommunicatewithaninstanceofSQLServer.PasswdPwdThepasswdftheSQLServeraccountloggingon.PersistSecurityInfofalse