Hi!
ADO is fine for 3-tire application. With SPT you require more programming, however it will have the best speed and will return data in the native VFP format. However, there is a problem in passing data between tires (if your application is physically separated to tires and some data required to be passed from one component to anotehr). ADO have its own built in approach to pass ADO recorsets between tires, that looks just like a returning reference to ADO object from the function in another component.
With remote views there are other messing, its have another advantages/disadvantages. Look to fox.wikis.com site, MoreOnRemoteViews article, that compares these 2 approaches. You can find there articles about ADO too.
>Hi,
>
>For those of you who are using VFP code with SQL Server, Oracle, DB2 or any other DB engine different than VFP's, I have a question:
>
>Which mechanism for working with client/server data are you using and why? I personnally know of two ways: Remote views and SQL Pass through. I know that ADO is a possibility. I want to construct the best 3-tier design possible so I need to understand the more technical issues behind each choice. I don't want to get stuck in two months thinking I should have gone another way.
>
>Thank you very much in advance for all the great advice you'll provide,
>
>Stephane.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.