I would recommend that you not directly access the data from ASP, but use middle tier COM objects to do this for you. There are several advantages:
- More clearly separates UI/Business/Data tiers
- Adds some additional security.
- You can directly access the tables from the COM object. No ODBC needed.
Another option is to use Web Connect.
>Currently a client has a Foxpro 2.6 for Windows application running. The application is stable. The .dbf files the application uses are also modified by an Active Server page via ODBC. The ODBC connections to the database are stable. Overall the client is happy with the stability of the database and the active server page.
>
>However, the client wants to move to VFP 6 with Stonefield Database toolkit and a "modern" VFP6 database. That is, a ".dbc" with triggers, cascading, and persistent relationships between tables.
>The problem is : ODBC does not support these activities. Thus, the ASP page accessing the data will not benefit from these enhancements only the Visual Foxpro application will benefit.
>
>My question : is ODBC stable when accessing VFP databases and tables that contain triggers, persistent relationships, and Stonefield?
>
>Is there a particular version of the ODBC driver that is recommended for VFP 6 databases using Stonefield?
>
>OR should I avoid the upgrade completely because ODBC will work properly?
>
>Although I will use an ODBC driver for VFP 6 databases I plan on treating the Foxpro ".dbf" files as though they do not have triggers or persistent relationships when dealing with them from the Active Server page.
>
>TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer