Need help with accesing data over a remote internet connection!

[bogdanlz]

Hi,

I have a VFP7 aplication. I need to acces data in VFP databases located on 10-12 remotes computers each conected to Internet using a cable modem broadband connect and running Win2000. How can i make it?

Tahnks,

Bogdan

 

[danceman]

go to microsoft knowledge base

http://support.microsoft.com/default.aspx?pr=kbinfo

do a search on "winsock control"

The Winsock control, invisible to the user, provides easy access to TCP and UDP network services. It can be used by Microsoft Access, Visual Basic, Visual C++, or Visual FoxPro developers. To write client or server applications you do not need to understand the details of TCP or to call low level Winsock APIs. By setting properties and invoking methods of the control, you can easily connect to a remote machine and exchange data in both directions.



Attitude is Everything

 

[wgcs]

In order to exchange the data, explore the new VFP7 functions CURSORTOXML() and XMLTOCURSOR()

 

[Mike Gagnon]

bogdantz

A couple of options come to mind:
1. Win2000 Terminal Server
2. The above with Citrix Metaframe software. You get more control with this.

It depends on your budget. Depending where you are in the world, and easely accessible things are.

We have built a Win2000 with Citrix Metaframe Server for under $10,000 (USD). One application running on the server and everybody usind minimum ADSL 1.7 (some T1 lines).

 

[bogdanlz]

Thanks for your responses,

I'm in Montreal and my clients are very tight on budget, so i must forget a server wich cost 9,000-10,000 USD (sorry mgagnon) so i will try the winsock solution for the moment.
I'll let you know if it worked.

 

[Mike Gagnon]

bogdantz

Montreal? really?

Pointe Claire---Work in Lasalle.

 

[bogdanlz]

mgagnon

Wow!

Montreal -- Work in Boucherville.

 

[Mike Gagnon]

bogdantz

So there are two VFP programmers in Quebec? ;-)

 

[bogdanlz]

mgagnon

Yesss sir!

 

[EzLogic]

You can also you afpweb that you could load on any IIS including win2k professional.

http://www.afpweb.com

i haven't used it, but I tryed their demo online and sounds good!!

Please let me know if this helped you

Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[bogdanlz]

Sorry for the delay, we adopted the following solution :

VPN. Terminal server. We take the advantage of a payments server

Cheers,

Bogdan

 

[Mike Gagnon]

bogdantz

You client's budget can't be all that tight. ;-)

 

[bogdanlz]

Hi mgagnon

In that case it is "la banierre" wich will pay for his members the VPN and all the kit. Our software will replace the TPV machines for Visa, Interac, etc.. with our keyboards with reading sensors. So we win the head office.

 

[Mike Gagnon]

Sounds like an interesting contract.

 

[bogdanlz]

Yes Sir,

Oui Monsieur!