Visual Studio 2003 连接SQL2000 "未将对象引用设置到对象的实例。"问题

问题：

使用VS2003用混合模式连接SQL2000数据库，例子如下：

            SqlConnection connection = null;
            SqlDataAdapter dataAdapter = null;
            DataSet dataSet = null;
            try
            {
                connection = new SqlConnection("server=127.0.0.1;database=qspcs;uid=qspcs;password=qspcs");
                connection.Open(); //报错 ： "未将对象引用设置到对象的实例。"
                dataAdapter = new SqlDataAdapter(sql, connection);
                dataSet = new DataSet();
                dataAdapter.Fill(dataSet);
                return dataSet;
            }
            catch (Exception exc)
            {
                errorMsg = exc.Message;
                return null;
            }
            finally
            {
                if (dataSet != null)
                {
                    dataSet.Dispose();
                    dataSet = null;
                }
                if (dataAdapter != null)
                {
                    dataAdapter.Dispose();
                    dataAdapter = null;
                }
                if (connection != null)
                {
                    connection.Close();
                    connection.Dispose();
                    connection = null;
                }
            }

问题原因一直没找到。直到发现了个帖子说是打个Microsoft Framework 1.1 service pack 1补丁就可以。

http://www.microsoft.com/downloads/details.aspx?FamilyID=a8f5654f-088e-40b2-bbdb-a83353618b38&displaylang=en 下载地址。

 

问题解决！！！

 

 

主要发现是System.Data版本升级引起的。。。。。。。。。。。。。。。