各位大哥，帮帮小妹！！！关于两个数据库之间的连接问题！

[liuzeru]

两个数据库分别在两个不同的机子上，想把他们连接起来，实现同时查询，可能吗？
1、sid：prince
ip：192.168.0.1
2、sid：princess
ip: 192.168.0.2
可不可以实现 select a.*,b.* from prince.tablename a,princess.tablename b

听说建立dblink可以，但怎么建？不会建！

[time_is_life]

you can execute directly

but you can execute two queries and put the datas into a dataset

then in the dataset
you can do whatever you want

[china2001ok]

i think so

[aspdotnet2005]

强烈关注，

[liuzeru]

这倒是，但是我不会用dblink，以前有人提过，我对dblink有强烈的好奇心，不知道它可以怎样解决这个问题

[blackhero]

dblink
是什么呀

[blackhero]

http://www.unix366.com/hgcxs/vngbosudqw/3377.htm

[凨叔]

提供一段创建本地连接linkedserver的代码。

string strSQL;
SqlConnection conn;
SqlCommand comm;
SqlDataAdapter da;
DataTable tb;

string strServer = "127.0.0.1";
string strUser = "sa";
string strPwd = "123456";

conn = new SqlConnection(......);
strSQL = "exec sp_helpserver";
da = new SqlDataAdapter(strSQL, conn);
tb = new DataTable();
da.Fill(tb);

strSQL = "";
if(tb.Select("name='" + strServer + "'").Length<=0)
{
strSQL += "EXEC sp_addlinkedserver @server = '" + strServer + "', @srvproduct = 'SQL Server' ";
}
strSQL += "EXEC sp_addlinkedsrvlogin @rmtsrvname='" + strServer + "', @useself='false', @rmtuser='" + strUser + "', @rmtpassword='" + strPwd + "'";
comm = new SqlCommand(strSQL, conn);
comm.ExecuteNonQuery();

[pengchengzhi]

上面的能解释一下？

[凨叔]

sp_helpserver:
Reports information about a particular remote or replication server, or about all servers of both types. Provides the server name, the server's network name, the server's replication status, the server's identification number, collation name, and time-out values for connecting to, or queries against, linked servers.

sp_addlinkedserver:
Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as Microsoft® SQL Server™, remote stored procedures can be executed.

sp_addlinkedsrvlogin
Creates or updates a mapping between logins on the local instance of Microsoft® SQL Server™ and remote logins on the linked server.