I just spent the afternoon on the phone to MS Tech support. For now at least it seems solved. There is a little known 'Known issue' regarding remote views. Even though the issue was raised from MS SQL, the fix seems to work for Oracle as well. It seems that when using multiple remote views on a single connection, it is not possible to precompile sql on server. By turing off the "precompile" check box, (or find/replace in GENDBC.prg generated code) it now works. I did get a new error message, but it should solve easily tommorow morning.

Thanks again for all your help.