>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?Not exactly. There were no changes to ODBC from VFP6 to 9 but changes to the tables. What is probably happening is that the old ODBC driver does not understand some of the new extensions you may have used in those tables.
If that is the case (and you do have the latest ODBC driver (albeit outdated), then your best way would be to use the latest OleDB provider instead (using ADO or ADO.Net for example).
http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=enTo double-check on table corruption, open the table(s) in question in VFP9 and look at them with an eye on the setting of SET TABLEVALIDATION.
