数据库连接字符串大全.doc

《数据库连接字符串大全.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、1.SQLServer (1)ODBC "Driver={SQLServer};Server=Chris;Database=pubs;Uid=sa;Pwd=sa" "Driver={SQLServer};Server=Chris;Database=pubs;Trusted_Connection=yes;" oConn.Properties("Prompt")=adPromptAlways oConn.Open"Driver={SQLServer};Server=Chris;DataBase=pubs;" (2)OLEDB,OLEDBConnection(.net

2、) "Provider=sqloledb;DataSource=Chris;InitialCatalog=pubs;UserId=sa;Password=sa;" "Provider=sqloledb;DataSource=Chris;InitialCatalog=pubs;IntegratedSecurity=SSPI;" (useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000) oConn.Provider="sqloledb" oCo

3、nn.Properties("Prompt")=adPromptAlways oConn.Open"DataSource=Chris;InitialCatalog=pubs;" "Provider=sqloledb;DataSource=192.168.0.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=sa;" (DBMSSOCN=TCP/IPinsteadofNamedPipes,attheendoftheDataSourceistheporttouse(1433

4、isthedefault)) (3)SqlConnection(.NET)"server=.;database=pubs;uid=sa;pwd=123456"–用户名密码方式"DataSource=.;InitialCatalog=MySchool;UserID=sa;Pwd=sa""DataSource=.;InitialCatalog=pubs;IntegratedSecurity=SSPI;"–SSPI方式"DataSource=Chris;InitialCatalog=pubs;UserId=sa;Password=sa;" "DataSource=Ch

5、ris;InitialCatalog=pubs;IntegratedSecurity=SSPI;" (useserverNameinstanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000) "DataSource=192.168.0.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=sa;" (DBMSSOCN=TCP/IPinsteadofNamedPipes,attheend

6、oftheDataSourceistheporttouse(1433isthedefault)) 2.Access (1)ODBC "Driver={MicrosoftAccessDriver(*.mdb)};Dbq=somepathmydb.mdb;Uid=Admin;Pwd=asdasd;" "Driver={MicrosoftAccessDriver(*.mdb)};Dbq=somepathmydb.mdb;SystemDB=somepathmydb.mdw;","admin","" (2)OLEDB,OleDbConnection(.NET)

7、 "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=somepathmydb.mdb;UserId=admin;Password=asdasd;" "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=somepathmydb.mdb;JetOLEDB:SystemDatabase=system.mdw;","admin","" "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=somepathmydb.mdb;JetOLEDB:Dat

8、abasePasswor