Re: How to update table on a remote server from NEWERA

Hi reddyr, I'm guessing you are trying to keep the data on the two servers in sync so why not just use synonyms and issue regular update statements rather than implicitly trying to connect to the remote server. I would suggest updating tables on the local server and then issuing updates to the remote tables (via synonyms) and doing all this within one transaction which means if either update fails then you can simply 'rollback' or in turn you can 'commit work' the data to both databases keeping them exactly in tune. thats my suggestion anyway ... cheers sandys On May 15, 7:04pm, REDDY@lmis wrote: > Subject: How to update table on a remote server from NEWERA > > Is there any way i can update table both on my local server and remote > server at the same time. Do I need to disconnect from local server before I > issue an implicit connection command? > > I tried to work through stored procedures but in vein!! > > Thanks:)) > > > >-- End of excerpt from REDDY@lmis