>1. local lan using a VFP 5.0a app 100+ users (no problem).
>2. Hosting on site a Webserver and a data server.(start of problem)
>3. access to the app data tables in #1 above from the internet (problem)
>
>I don't want to use ODBC to connect to the tables as I am expecting 10,000-100,000 hits a day.
>This is where I need some advice. I am running a NT server and have SQL 6.5.My web hosting
> software is IIS 3.0. The people on the local lan will be updating the same information as
>the people on the web.I'm in a pickle and would appreciate any and all help.

There are a number of tools that allow you to build Web applications with Visual FoxPro data.
Active Server is Microsoft's recommended route although I don't recommend this for VFP
at this time (not 'til 6.0 ships). Active Server allows access via ODBC *or* via VFP
Automation servers which you can call out of scripted pages. The latter is quite powerful,
but unfortunately hobbled by VFP's current COM threading model limitations.

VFP 5.0a also ships with FoxISAPI which is an Automation server interface that allows you
to directly call VFP servers from your Web pages. Unlike ASP, FoxISAPI is an all VFP solution
that also overcomes the threading model limitations by providing a pool manager. FoxISAPI
is quite capable of serving the load you are expecting.

In addition to the MS provided tools there are also third party tools. My company publishes
West Wind Web Connection which is a lot like FoxISAPI on steroids {s}. Besides the more solid
implementation it also features a very full featured Web application framework for building
Web applications with Visual FoxPro. Features include dynamic VFP form rendering as HTML,
remote server management and transparent support for standalone applications/IDE operation
or Automation server deployment with a simple compiler switch (this means you can actually
debug your servers interactively which is not possible with Automation servers since they're
compiled).

To be fair, there are other third party tools: X-Works (used on this site), FoxWeb and a few others.

Regards,

+++ Rick ---