.Net中如何連接配接到ODBC資料源

1.下載下傳ODBC.NET (FrameWork 2.0以上預設未安裝)

2.建立項目，添加Microsoft.Data.ODBC.dll 引用

3.cs代碼如下:

using System.Data;

using Microsoft.Data.Odbc;

4.連接配接代碼示例:

SqlServer:

OdbcConnection cn;

        OdbcCommand cmd;

        string MyString;

        MyString="Select * from Customers";

        cn= new OdbcConnection("Driver={SQL Server};Server=mySQLServer;UID=sa;

                               PWD=myPassword;Database=Northwind;");

        cmd=new OdbcCommand(MyString,cn);

        cn.Open();

        MessageBox.Show("Connected");

        cn.Close();

OLEDB JET:

        MyString="Select * from Titles";

        cn= new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};

            DBQ=D:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb;UID=;PWD=;");

Oracle:

       OdbcCommand cmd;

       string MyString;

       MyString="Select * from Customers";

       cn= new OdbcConnection("Driver={Microsoft ODBC for oracle};Server=myOracleServer;

                               UID=demo;PWD=demo;");

       cmd=new OdbcCommand(MyString,cn);

       cn.Open();

       MessageBox.Show("Connected");

       cn.Close();

DSN:

       cn= new OdbcConnection("dsn=myDSN;UID=myUid;PWD=myPwd;");