各种数据源连接各种数据库常用连接字符串
2008-08-12 13:58
对各种数据源连接各种数据库常用连接字符串,归纳了一下,如下:
(一)常用连接: 1.使用SqlConnection对象: public void SqlConnectionOpen() { SqlConnection conn= new SqlConnection(); conn.ConnectionString = "user id=sa;password=;initial catalog=northwind;datasource=localhost;connect 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(); } (二)其它: 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;"); |