>We are using ColdFusion to connect to VFP tables through an ODBC datasource. We recently updated the database (using VFP 9) and are now getting a 'Not a table' error when trying to access that table. I know there were ODBC changes from VFP 6 to 9. How can I still use ColdFusion to connect to these 9.0 tables? Thanks,
The VFP ODBC driver didn't change since VFP6SP5 so it cannot work with tables of type 49 or 50 (SYS(2029)). They can only be accessed through VFP OLE DB provider.
--sb--