下面是连接Sql2000的代码:
            SqlConnection cn = new SqlConnection(@"Data Source=192.168.0.139;Initial Catalog=myBlog;User ID=sa;PassWord=");
            try
            {
                cn.Open();
                SqlCommand cmd = new SqlCommand("Select * From Blog", cn);
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    MessageBox.Show("读取数据成功");
                }
                else
                {
                    MessageBox.Show("未找到数据");
                }            }
            catch (System.Data.SqlClient.SqlException ex)
            {                MessageBox.Show(ex.Message);
            }
            finally
            {
                cn.Close();
                cn.Dispose();
            }存在的问题:
1、我机子(192.168.0.139)上有Sql2000(默认实例名),SQL2005实例名(SQL2005),2005MSDE实例名(SQLEXPRESS)
而我这个代码只能连接上SQL2000,我把连接串改了,如SqlConnection(@"Data Source=192.168.0.139\SQL2005;Initial Catalog=myBlog;User ID=sa;PassWord=");,都不能连上
2、局域网另一台电脑192.168.0.1  SQLSERVER2000  我连接串改成new SqlConnection(@"Data Source=192.168.0.1;Initial Catalog=myBlog;User ID=sa;PassWord=");同样连不上,请问是什原因??(PDA是无线连入局域网)