ODBC && OLE DB.NET DATA PROVIDER

ODBC数据源连接集合【 ODBC .NET DATA PROVIDER】

using System.Data.Odbc;
string str=@"DSN=guangzi";//创建DSN数据源
OdbcConnection conn=new OdbcConnection(str);
conn.Open();

 

Access:
string str="provider=Mrcrosoft.Jet.OLEDB.4.0;Data Source=D:/ASP.NET/acc.mdb";
OdbcConnection Conn=new OdbcConnection(str);

 

SQL Server:
@"Driver={SQL Server};Server=(local);Database=MyDB;User ID=sa;password=mysa";

 

mySQL:
string strBase=@"Driver=MySql ODBC 5.1 Driver;Server=localhost;Database=test;uid=guangzi";

 

Excel:
string str=@"DSN=myexcel";//使用 ODBC 建立连接数据源
OdbcConnectin conn=new OdbcConnection(str);

OLE DB 数据源连接集合【 OLE DB.NET DATA PROVIDER】

 

Access:
string str="provider=Mrcrosoft.Jet.OLEDB.4.0;Data Source=D:/ASP.NET/acc.mdb";
OleDbConnection Conn=new OleDbConnection(str);

 

SQL Server:
OleDbConnection conn=new OleDbConnection();
conn.ConnectionString="Provider=SQLOLEDB;Data Source=(local);Initial Catalog=myTable;uid=sa;pwd=sa;";

 

Excel:
string str="provider=Mrcrosoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data.xls")+";Extended Properties=Excel 8.0;";
OleDbConnection Conn=new OleDbConnection(str);

 

sybase:

Provider=Sybase.ASEOLEDBProvider.2;Data Source=DATA;Initial Catalog=database;User ID=gz;Password=guangzi;