.NET使用ODBC连接SQL Server2005示例

using System;
using System.Data;
using System.Data.Odbc;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            using (OdbcConnection conn = new OdbcConnection("DSN=MyDSN;Uid=sa;Pwd=sa;"))
            {
                conn.Open();
                using (OdbcCommand cmd = new OdbcCommand())
                {
                    cmd.Connection = conn;
                    cmd.CommandText = "Select TOP 1 [Sender] FROM [MSG_Inbox]";
                    object val = cmd.ExecuteScalar();
                    Console.WriteLine(val);
                }
                conn.Close();
            }

            Console.WriteLine("ok");
            Console.ReadLine();
        }

    }
}

OdbcConnection conn = new OdbcConnection("DSN=MyDSN;DATABASE=WHMMS;Uid=sa;Pwd=sa;")