This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教：怎样从一个sql-server 访问(remote)另外一个sql-server, 用ip address？
-pingpong(乒乓);
2002-12-3
(#892377@0)
-
up
-pingpong(乒乓);
2002-12-3
(#892381@0)
-
sp_addlinkedserver 或其它什么的，总之是把远程sql server在自己注册一下
-miketany(MIKE老狼);
2002-12-3
(#892386@0)
-
多谢！我记得有一种方法是：把remote server 的ip address 和 log in information 嵌在sql 语句中。这方法可以吗？
-pingpong(乒乓);
2002-12-3
(#892402@0)
-
没见过这种用法，感觉应该不行
-miketany(MIKE老狼);
2002-12-3
(#892416@0)
-
is that?
-henhen(哼哼, PtoPing);
2002-12-3
{1112}
(#892482@0)
-
Thanks! I don't understand very well.Could you please tell me where are the article from?
-pingpong(乒乓);
2002-12-3
(#892537@0)
-
sql server books online. lots of stuff. maybe it is installed with sql server 2000.
-henhen(哼哼, PtoPing);
2002-12-3
(#892547@0)
-
Thanks! Are you the henhen mm in 001? How about your new place? Is everything OK?
-pingpong(乒乓);
2002-12-3
(#892602@0)
-
yes. Thanks.I always use this nickname. the town is not bad. :))
-henhen(哼哼, PtoPing);
2002-12-3
(#892604@0)
-
Do you mean openrowset ? openrowset is one time ，ad hoc method to connect and access remote data using OLE DB,in which you can specify the data source and login info.
-yangn(Raymond);
2002-12-3
(#892488@0)
-
Thanks!
-pingpong(乒乓);
2002-12-3
(#892539@0)