C#数据库远程连接

Question

boyyao(迷失在网络 (每天12小时在线)) 说的应该是了。

Answer 1

"data source=" + this.server + ";initial catalog=" + this.db + ";persist security info=False;user id=" + this.cnn_user + ";password=" + this.cnn_password + ";packet size=4096";

Answer 2

在SQL SERVER中新建一个登陆324，设置密码为324，并映射到要链接的数据库
假设SQL SERVER的名称为CMEN
连接字符串可以为”server=CMEN;database=pub;uid=324;pwd=324“

Answer 3

非典型数据库的例子
我的例子。连firebird的。免费数据库。
string connectionString = "User=SYSDBA;" +
"Password=tzh;" +
"Database=record;" +
"DataSource=10.1.10.35" +
"Port=3050;" +
"Dialect=3;" +
"Charset=NONE;" +
"Role=;" +
"Connection lifetime=15;" +
"Pooling=true;" +
"Packet Size=8192";FbConnection myConnection1 = new FbConnection(connectionString);
FbConnection myConnection2 = new FbConnection(connectionString);
FbConnection myConnection3 = new FbConnection(connectionString);典型数据库的例子
再给个mssql里northwind的例子吧
private void buttonLoad_Click(object sender, System.EventArgs e) {
            Cursor currentCursor = Cursor.Current;
    SqlConnection con = new SqlConnection("workstation id=TZH;packet size=4096;integrated security=SSPI;data source=TZH;persist security info=False;initial catalog=Northwind");//原本的那个是不对的。
//我机器上要这样写话
//"workstation id=TZH;packet size=4096;integrated security=SSPI;data source=TZH;persist security info=False;initial catalog=Northwind"
//"server=(local)\\NetSDK;Integrated Security=SSPI;database=northwind");
            try {
                Cursor.Current = Cursors.WaitCursor;
                //Fill the DataSet
                SqlDataAdapter cmdCustomers = new SqlDataAdapter("Select * from Customers", con);
                SqlDataAdapter cmdOrders = new SqlDataAdapter("Select * from Orders", con);
                SqlDataAdapter cmdOrderDetails = new SqlDataAdapter("Select * from [Order Details]", con);
customersDataSet1.Clear();
                statusBar1.Text ="Loading Customers...";
                cmdCustomers.Fill(customersDataSet1, "Customers");
                statusBar1.Text ="Loading Orders...";
                cmdOrders.Fill(customersDataSet1, "Orders");
                statusBar1.Text ="Loading Order Details...";
                cmdOrderDetails.Fill(customersDataSet1, "Order_Details");
                statusBar1.Text ="Updating Grid...";
            } finally {
                statusBar1.Text ="Done";
                Cursor.Current = currentCursor;
                con.Close();
            }