Yep, you are right - I sometimes forget about using COM/DCOM possibility. Or even an executable app (maybe as service) that runs on the server allowing connection (maybe on TCP/IP with winsock) to query it. Another possibility is to utilize FoxISAPI.dll or ASP and again to turn the data retrieval and manipulation part of the VFP application to VFP COM classes.
>Zlatin has a point about VFP not being a server app. Perhaps if you don't wish to upsize to SQL you could use a COM object that would run on the server forcing the processing to be done on the server and only pass back the results. Not sure if this is feasible in your position but just a thought.
>
>Aloha,
>
>James
< snip >
>>In that case I suggest to move to C/S (or n-tier) ASAP. You have at least two possibilities for upsizing:
< snip >
Greetings
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!