Re: Exchanging data between two instances
This definitely looks like a job for dbcopy.ec.
Art S. Kagel
Rob Gale wrote:
>
> Here's what a (truncated) dbaccess screen gives:
>
> ------------ rgtest@e6000dsa73_tcp ------------- Press CTRL-W for
> Help --------
>
> insert into lu_item
> select * from zulu_full@e6000xps821_tcp:lu_item;>
> [blank lines deleted]
> 908: Attempt to connect to database server (e6000xps821_tcp, conerr=-908,> o
> ----------------------------------------------------------------------------
> -----------------------------
> This occurs despite the fact that I can connect to each database separately!
>
> I have tried using the V8 and V7 dbaccess to do this with no joy.
>
> Rob
>
> David Link <dalink@West.com> wrote in message
> news:7nlsjl$bnq$1@news.xmission.com...
> >
> > Rob,
> > This should work however I believe that it is
> >
> > insert into ourtable
> > select * from yourdb@yourserver:ourtable;> >
> > If this doesn't work let me know what the errors are.
> >
> > David Link