Re: remote server question

From: "Michael Talbot" <michael.talbot@telops.gte.com> > > I have the following scenario > >Server1 >Server2 > >Database Server 'Test' exists on both machines in both also contain >database >'mydb' > >If I am connected to db server Test and db mydb on Server 1 , I can access >a >table with the following statement > >select * from mydb@Test:atable> >Is it possible to add Server2 to the statement so that I may select from >it >while I am connected to Server1. No, you should create instance test1 and test2, then you can distiguish between local and remote selects. You also have to add each other's sqlhosts entries, create each other's services and add each other to .rhosts or /etc/hosts.equiv. >My guess is I would have a passwd problem, but was curious if anyone knew >if >this could be done. If you have a password problem, you haven't set up hosts.equiv. :) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com