Beema wrote:
>>We're getting some weird results...
>>
>
>
> OK, after much messing around, the problem has been solved...
>
> If a new table was created in MSSQL, then Heterogeneous Services would pick
> up the table & insert OK.
> If a table was changed in MSSQL, then local session in Oracle must be closed
> & re-opened, before the changes were recognised.
>
> Thanks for your help Daniel..
Happy to take the credit but I think you solved this one on your own.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Feb 23 2004 - 17:40:07 CST
