连接字符串汇总

连接字符串汇总 (一)常用连接: 1.使用SqlConnection对象: public void SqlConnectionOpen() { SqlConnection conn= new SqlConnection(); conn.ConnectionString = "user id=sa;password=;initial catalog=northwind;datasource=localhost;c onnect Timeout=20"; conn.Open(); } 2.使用OleDbConnection对象: public void OleDBConnectionOpen() { OleDBConnection conn = new OleDbconnection(); conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Customer.mdb"; conn.Open(); } (二) ODBC连接 1.ODBC连接Access本地数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:\a.mdb;"+ "Uid=Admin;"+"Pwd=;"); 2.ODBC连接Access系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:\a.mdb;"+ "SystemDB=Admin;"+"Pwd=;"); 3.ODBC连接Access系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=\\server\share\a.mdb;"); 4.ODBC连接Excel系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.xls)};"+"DriverId=790;"+ "Dbq=C:\a.xls;"+"DefaultDir=c:\somepath;"); 5.ODBC连接Oracle系统数据库 conGoodDay.Open("Driver={Microsoft ODBC for oracle};"+"Server=OracleServer.world;"+ "Uid=Admin;"+"Pwd=password;"); 6.ODBC连接Sql Servr conGoodDay.Open("Driver={Sql Server};"+"Server=myServer;"+"Database=myDatabaseName;" "Uid=Admin;"+"Pwd=password;"); 7.ODBC连接Visual FoxPro conGoodDay.Open("Driver={Microsoft Visual FoxPro Driver};"+ "SourceType=DBC;"+"SourceDB=c:a.dbc;"+"Exclusive=No;"); (三)access连接汇总 OLE DB, OleDbConnection (.NET) Standard security: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" With password: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;" (四) Access ODBC Standard Security: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" Workgroup: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" Exclusive: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=" OLE DB, OleDbConnection (.NET) Standard security: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" Workgroup (system database): "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;" With password: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;" (五) ODBC Driver for Oracle For the current Oracle ODBC Driver from Microsoft: oConn.Open "Driver={Microsoft ODBC for Oracle};" & _ "Server=OracleServer.world;" & _ "Uid=myUsername;" & _ "Pwd=myPassword;" For the older Oracle ODBC Driver from Microsoft: oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _ "ConnectString=OracleServer.world;" & _ "Uid=myUsername;" & _ "Pwd=myPassword;" OLE DB Provider for Oracle (from Microsoft) oConn.Open "Provider=msdaora;" & _ "Data Source=MyOracleDB;" & _ "User Id=myUsername;" & _ "Password=myPassword;" For more information, see: Microsoft OLE DB Provider for Oracle OLE DB Provider for Oracle (from Oracle) For Standard Security: oConn.Open "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User Id=myUsername;" & _ "Password=myPassword;" For a Trusted Connection: oConn.Open "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User Id=/;" & _ "Password=;" ' Or oConn.Open "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "OSAuthent=1;"