Which way: SQL Passthrough or ADO?

[phita]

Hi guys,
One question please: Which is the best & fastest technology to work remote data? SQL Passthrough or ADO?

Thanks.

 

[rgbean]

Both / Neither. It depends on the what you are doing (query, update, stored procedures), the Database you are talking to (MS SQL Server, Oracle, MySQL, etc.) and the ODBC / OLEDB drivers you are using.

It's always best to try some sample code in your situation to determine what's best for you.

Rick

 

[phita]

Thanks Rick for your suggestions. I will try both methods and find out the best for me. I am especially concerned with data fetching and updating.

Phita.

 

[rgbean]

It's been suggested by some, that in many cases, SPT is best for queries, and ADO is best for updates and SP calls. In other words, one solution may not be the best for all cases.

Rick

 

[Mike Lewis]

Hi Phita,

I would vote against ADO in most cases.

ADO is great in VB, but I believe adds unnecessary complicaions in VFP. Its aim is to give you a recordset that you can easily navigate, update, etc. But VFP already has its own excellent features for those tasks.

Of course, it's all a matter of personal style and preference, but I would go with SQL Pass-Through almost all the time. Remote views are another possibility: they are less capable than SPT, but much simpler to work with.

Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk