Here's the situation: We have a rather large application that runs fairly well locally but becomes painfully slow over the network when faced with some of our larger queries. I ran into this problem a few years back and solved it by accessing our own data through odbc. The performance gains were only realized because of how poor the network was.
Basically we want to try the same thing here using oledb.
Just so you know...
>You can use CursorAdapter with ADO.
>
>>I want to execute SP in the database to return VFP cursor. I found this sample in WiKi
>>
http://fox.wikis.com/wc.dll?Wiki~VFPOleDBProvider~VFP>>however it returns Record Set. Is my only way to receive record set first and then convert it to a cursor?
>>
>>In other words, assuming I have the following SP in the database
>>function test_sp
>>select * from Users into cursor curTest
>>return
>>
>>I now need to execute this SP and return this curTest cursor.