>Had anyone had any good success with using VFP for the driving database for a web site? I am working
>on a couple sites that need databases for USERS, EVENTS, and PRODUCTS. One will probably take
>orders as well. I have always used VFP over Access for commercial applications because it seems to
>be more powerful and more controllable but everywhere I look, most examples and tutorial help for web
>site design using ASP or JAVA uses Access for the database.
>
>I started designing one site and got it too look up the data using VFP successfully but am running into
>all kinds of problems with updating and deleting and the resources don't cover VFP issues.
>
>Suggestions
Hi Peter,
We have built several data driven sites using VFP as the data engine. You either build COM components in VFP for your data access, then manipulate the objects in ASP, or you you can create a DSN or DSN-less connection through the VFP ODBC driver. The first requires the web server to have the VFP runtimes, but the COM objects use the tables just as you would in normal VFP code. The second requires that the webserver has the VFP ODBC drivers, and requires more scripting in the ASP page to manage the data.
What are the problems, specifically, you are running into with updating or deleting data?