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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only