FoxPro Table Stored On the Web

[HerbertDB]

Hi,


Is storing tables in a web server and accessed by FoxPro application
over the Internet possible? Can you point me to a nice article about
this. Thanks


Brgds,
Herbert

[HerbertDB]

Im reading about FoxISAPI but is there options for Linux Based Server?

Post by HerbertDB
Hi,
Is storing tables in a web server and accessed by FoxPro application
over the Internet possible? Can you point me to a nice article about
this. Thanks
Brgds,
Herbert

[Villi Bernaroli]

Post by HerbertDB
Is storing tables in a web server and accessed by FoxPro application
over the Internet possible? Can you point me to a nice article about
this. Thanks

There are so many ways one could implement that...
One way: a VFP dll which offers methods to access tables, then you use ASP
under IIS to receive the calls from the clients so that ASP calls the DLL
and gets the data.
Or a webservice, which again is a VFP dll (better a mtdll) hosted in IIS,
which receives calls and answers serving data to the invokers out there.
Or some kind of VPN based file sharing sustyem.
It mostly depends on what are you going to do with those "tables in a web
server and accessed by FoxPro application over the Internet". Will this be a
web-application or just a classic client-server application where data
should be over the internet? Why this: is it a distributed servers
application?
Regarding Linux: a Samba shared folder can contain vfp tables and then the
LAN PC using a VFP application under windows can access the tables, but '0m
talking LAN. If you want to go the internet way, you should again think
about VPS's and theyr pro's and con's.

[HerbertDB]

I will be developing a online inventory system where different
offices can request items through the internet. So there will
definitely updating of records online.

Post by Villi Bernaroli

Post by HerbertDB
Is storing tables in a web server and accessed by FoxPro application
over the Internet possible? Can you point me to a nice article about
this. Thanks

There are so many ways one could implement that...
One way: a VFP dll which offers methods to access tables, then you use ASP
under IIS to receive the calls from the clients so that ASP calls the DLL
and gets the data.
Or a webservice, which again is a VFP dll (better a mtdll) hosted in IIS,
which receives calls and answers serving data to the invokers out there.
Or some kind of VPN based file sharing sustyem.
It mostly depends on what are you going to do with those "tables in a web
server and accessed by FoxPro application over the Internet". Will this be
a web-application or just a classic client-server application where data
should be over the internet? Why this: is it a distributed servers
application?
Regarding Linux: a Samba shared folder can contain vfp tables and then the
LAN PC using a VFP application under windows can access the tables, but
'0m talking LAN. If you want to go the internet way, you should again
think about VPS's and theyr pro's and con's.
--
Villi Bernaroli, Italy
VFP, SOAP, MS SQLserver, MySQL, Oracle

[swdev2]

You might want to consider, as well, having a call to a php library on a
webserver. there's a php 'link' for fox2x database file, as well. Can make
low level wininet call to sling things back and forth.

I'd suggest some redesign, though, if possible, and use mySql with php on
the backend, expose a soap interface on any vfp-client side. (if using a
shared-services linux hosting company). If you need some 'code review' on
that paradigm - take a look at the soap interface on osCommerce - can sling
data in/out of that with VFP and a soap connector.

Good Luck !
Mondo Regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

Post by HerbertDB
I will be developing a online inventory system where different
offices can request items through the internet. So there will
definitely updating of records online.

Post by Villi Bernaroli

Post by HerbertDB
Is storing tables in a web server and accessed by FoxPro application
over the Internet possible? Can you point me to a nice article about
this. Thanks

There are so many ways one could implement that...
One way: a VFP dll which offers methods to access tables, then you use ASP
under IIS to receive the calls from the clients so that ASP calls the DLL
and gets the data.
Or a webservice, which again is a VFP dll (better a mtdll) hosted in IIS,
which receives calls and answers serving data to the invokers out there.
Or some kind of VPN based file sharing sustyem.
It mostly depends on what are you going to do with those "tables in a web
server and accessed by FoxPro application over the Internet". Will this be
a web-application or just a classic client-server application where data
should be over the internet? Why this: is it a distributed servers
application?
Regarding Linux: a Samba shared folder can contain vfp tables and then the
LAN PC using a VFP application under windows can access the tables, but
'0m talking LAN. If you want to go the internet way, you should again
think about VPS's and theyr pro's and con's.
--
Villi Bernaroli, Italy
VFP, SOAP, MS SQLserver, MySQL, Oracle

[tg]

Post by HerbertDB
I will be developing a online inventory system where different
offices can request items through the internet. So there will
definitely updating of records online.

Rick had an article on a client-server component
to query/update a fox table on a server.
wwHttpSQL was the name AFAIR - search WestWind.Com
If you don't want to go to a real DB server
probably the best step - usually everything works,
if you need some enhancements, you can add to the code:
reading Rick's code is always instructive
and his designs are usually quite adaptable.

my 0.05 EUR (been there, read it <g>)

thomas