C# 中连接ODBC数据源的问题

[rbc16]

我用ODBC健了一个数据源
SQL Server 2000
数据源名为ZJWCTaxManagerDB
数据库名为ZJWCTaxManagerDB
用户名 sa
密码 sa

请问应该怎么在C#中链接阿？

[rbc16]

用的是Viual Studio 2005

[kissknife]

类似：
OdbcConnection conn = new OdbcConnection("dsn=ZJWCTaxManagerDB");
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = conn;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
string sql = "Select * from ......";
cmd.CommandText = sql;

try
{
da.Fill(ds);
Console.WriteLine(ds.Tables[0].Rows.Count);
}
catch (Exception x)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
Console.WriteLine(x.Message);
}
Console.Read();

[kissknife]

须要：
using System.Data.Odbc;
using System.Data;

[hertcloud]

System.Data.Odbc.OdbcConnection con =new System.Data.Odbc.OdbcConnection("server=.\ZJWCTaxManagerDB;uid=sa;pwd=sa;database=ZJWCTaxManagerDB;");

[davidyoung821]

System.Data.Odbc.OdbcConnection con =new System.Data.Odbc.OdbcConnection("DSN = ZJWCTaxManagerDB; UID = sa; PWD = sa");

con.Open();