table

[inteleserve]

I have a table that I would like to access from a webpage. How do I go about doing this. Obviously I would want to have a secure login ect. Could anyone point me in the right direction???


Thanks,

Ross

 

[BPeisch]

There really isn't a simple answer to your question. FoxISAPI is something that ships with VFP, which allows you to create internet apps. Older versions were kind of flaky, but they've improved the one with VFP 8 a lot. There's also a sample app with VFP 8 that shows how to use it.

You should also take a look at Rick Strahl's book on "Internet Applications with Visual FoxPro 6". (Don't worry about the title, most of it applies to all versions of VFP.) You can get it from

http://www.hentzenwerke.com

There are also several third party frameworks for creating internet apps with VFP. The most popular are:

• Web Connection (

http://www.west-wind.com

)
• Active FoxPro Pages (

http://www.afpages.com

)
• ActiveVFP (

http://www.dotcomsolution.com

)
• FoxWeb (

http://www.foxweb.com

)



-BP (Barbara Peisch)

http://www.peisch.com

 

[jimoo]

There are a few ways to do this. One of the ways that is often discussed by others, but in my opinion lacks practical examples is the latest Microsoft OLEDB provider.

Go here and click on the VPF 8.0 link and it will provide a sample of the driver.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForVisualFoxPro

However, this doesn’t fully answer you question, “…how to access it from a webpage.”

Here is a similar thread, recently posted:
ODBC Connection to VFP8 Database
thread184-777762


I use Rick Strahl’s web-connect. You can read more about the product at

http://www.west-wind.com

You can see some samples under,

http://www.deltabg

Go to samples.

The first one simply retrieves the data, and allows you to update it using HTML. Click on the link "Retrieve / Update Sample Customer Data"

Others are more advanced.

This code, although powerful, has a bit of a learning curve.


Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com