>I have an application developed in VFP 7.0 with remote views to either an MS SQL or VFP backend. In trying to get a proof of concept and a level of effort involved to upgrade it to VFP 9.0, I stumbled on incosistent and ODBC errors of 1526 Not a table type of erros.

The VFP ODBC driver didn't change since VFP6SP5. It doesn't support any new features introduced after VFP6, like DBC events, AutoInc fileds, e.t.c. The tables with such features will have type 49 or 50 (SYS(2029)). The ODBC driver will generate error 1526-'Not a table' for them.