Hi Alex,
I am once again back to ColdFusion; I've gone some things working easily in MS Access, but not Visual FoxPro still; I've noticed that one table I was trying to access is a FoxPro for DOS file, probably 2.6a. I even went on a Forum that is for ColdFusion programmers, but most of those guys can't even spell FoxPro, so they don't know anything. The forum is
www.Tek-Tips.com I'm putting together a few pages in ColdFusion and WebConnection to display MSDS's, which are Material Safety Data Sheets.
Cecil
>>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=en>To 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.