The other day, someone asked me a question that partly stumped me.

Basically, suppose someone had a front-end written in VFP that accessed SQL Server tables. The front-end was running on a client's laptop, the SQL Server database was running at a corporate location, and the client had nothing more than an ISP dial-up at less than 56 kbs.

Most of the VFP->SQL Server setups I've seen have still involved LANs or Citrix, so I basically have two questions:

1) From a syntax standpoint, what would you need in addition to the standard SQLCONNECT/SQLEXEC commands to an ODBC source? (As far as connection strings, etc.)

2) Does this type of setup (someone accessing SQL Server tables from a VFP front-end with a dial-up connection of 56 kbs or less) even make sense?

Kevin