应用程序中的服务器错误。不支持关键字: “dsn”。

Question

public static OdbcConnection Connection
        {
            get
            {
                string connectionString = "dsn=phpcms ;driver={mysql odbc 3.51 driver}; server=localhost;uid=root;pwd=;database=phpcms";
                if (conn == null)
                {
                    conn = new OdbcConnection(connectionString);
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }
                return conn;
            }
        }

Answer 1

你可以用VS-视图-服务器资源管理器先连接下数据库。。直接复制连接后的字符串就OK了