The West Wind Web Store is designed primarily for use with SQL Server/MSDE, but it will also work Visual FoxPro data via the Visual FoxPro OleDb Provider.
In order to use Visual FoxPro data you'll need to:
- Download the Visual FoxPro 8.0 OleDb Provider
It's important that you get the latest OleDb driver as the original VFP 8 OleDb driver was lacking a number of features when used with ADO.Net. You should use the the driver either from SP1 of VFP 8 or download from the above link (or newer). - Copy the Visual FoxPro Database directory
The Web Store ships with a database preconfigured in the DataTemplates\VisualFoxPro directory. Take the content of this directory and copy it to a new location in order to preserve the original files. Make sure you mark this directory so that the ASPNET (windows 2000,XP) or NETWORK SERVICE (Win2003 Server) account have full rights on this directory so that the ASP.Net application can access the data. - Configure the Web Store to use the data
Make sure you ran the installation for the Web Store and you configured the Virtual Directory and the application is up an running. Make sure you can access the Administration Page. Go to the Web Store Configuration link. Click on the Configuration tab and change:
- The Data Class Interface
Visual FoxPro OleDb Provider
- Database Connection String
Provider=vfpoledb;Data Source=D:\projects\webstoredbfdata\webstore.dbc;
where you substitute the path where you copied the files. Note that if you store data on another machine you will need to make sure that the ASP.Net account configured to run the application has rights in this directory. This can be complicated if you use the stock accounts - in this case it's recommended you explicitly configure the ASP.Net application to use a specific user account that has rights on both the local machine (Web Server) and the data server.
That's all that's needed to start using Visual FoxPro data.
There's additional information available about using Visual FoxPro datasources in general with the Business Object framework at in the Visual FoxPro Databases Topic
See also
Visual FoxPro Databases