>We have been using the Jet Databases engine (dao.dbengine.35) to access foxpro 2.6 files from ASP. I was recently told that the latest version of the database engine no longer supports accessing Foxpro databases.
>
>I have two problems. I would like to start using VFP tables and be able to read and write to them. I don't want to use ODBC if at all possible. Jet does not look like a vialbe solution for very long. How are you accessing VFP tables? Are you using ADO? Doesn't it require ODBC?
You can do it with ADO, but it still requires the VFP ODBC driver since there is no native OLEDB provider for VFP (yet). FWIW, the Jet engine cannot directly read VFP tables, but I believe the latest version of DAO (4.0) still supports reading FoxPro 2.6 tables.