数据库连接字符串

1.使用SqlConnection对象:     

 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";

  1.ODBC连接Access本地数据库

  conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:/a.mdb;"+    "Uid=Admin;"+"Pwd=;");     conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:/a.mdb;"+   "SystemDB=Admin;"+"Pwd=;");     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;"  

7.ODBC连接Visual FoxPro

  conGoodDay.Open("Driver={Microsoft Visual FoxPro Driver};"+  "SourceType=DBC;"+"SourceDB=c:a.dbc;"+"Exclusive=No;");