John...
The difference of working with an ADO command object vs. SPT is like night and day. For starters, the ADO command object has a parameters collection. This of course, is assuming you are using stored procs. If you are not, you are already behind the 8-ball. And, whether you work with SPT or and ADO command object, you are still rendering SQL from the client - which is very inefficient.
So, if you are rendering SQL updates from the client, THAT is the issue. The issue of whether to use SPT or ADO is a red-herring. In that case, it really does not matter.
If on the other hand, you doing thing things as efficiently as possible, using stored procedures, then ADO/OLE DB is a much faster and a much more efficient way of working with remote data - especially update operations.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only