>> >In a scenario where our client will be using our program as a "closed"
>> system, however, we want of course to put VFP databases on the server. We
>> have downloaded the latest VFP ODBC driver from Microsoft and seem to be
>> doing everything according to the book, but all of the generated SQL code
>> causes errors of various kinds. However, if I build a remote view to an
>> Access database or a SQL server database, using the respective ODBC
>> drivers, everything works perfectly.
>> >
>> >Why doesn't VFP want to let us do this with VFP databases?
>
>Have you tried running all of the database stuff outside of the
>application -- that is, opening the connection, retrieving data,
>updating data, etc., from the Command Window.
>
>/Paul

Yes, the connection is live and retrieving and updating data works -- including from the remote view, as long as we don't attempt to build a left outer join -- that is, any generated SQL code that involves a join will fail in all situations.

Thanks.