Cool, David ---

Please share whatever you find out. I seem to recall that the methods were DAO-like.


>Thanks for the info John! It been very helpful. I have been playing with the Oracle Objects inprocess server today. I created an inproc automation server using the Oracle's inproc server and it seems to have alot of potential. Unlike most of the documentation I've read so far, you do not have to send arrays or comma delimited strings to pass information from the middle tier to the client. I even heard of one person saving the returned query to a table in a shared directory on a file server?!?!?! You can pass results obtained from a query as an object back to VFP with the Oracle objects. Still doing a lot of research. You do need SQL NET installed on the middle tier machine, and, I'm assuming, you would also need the Oracle ODBC driver as well (have to confirm this yet). I'll let you know what I find out though.
>
>>David ---
>>
>>It's hard to find VFP specific documentation for ADO, OLE DB, or any other data access technology that doesn't involve native DBFs. Try looking at www.microsoft.com/data ... the examples are mainly in VB but the syntax is very similar to VFP.
>>
>>
>>>Which brings me to my next question:
>>>
>>>Never used VB, ADO or OLE DB. I vaguely know what they are. Any suggested resources or examples for VFP?
>>>
>>>>Hi David...
>>>>
>>>>I briefly worked with it on a VB project several months ago...internally I'm not sure how it works but I do think it requires ODBC. It was OK...I think I'd much rather look at ADO and OLE DB for speed, ease-of-use if I were you.
>>>>
>>>>
>>>>>Heard rumor that by using Oracle API that there was no need to install SQL NET or ODBC driver on clients.
>>>>>
>>>>>1) Does anybody know if it is true?
>>>>>2) Anybody actually done it? If so, how?!?!?
>>>>>
>>>>>Any help would be appreciated.
>>>>>
>>>>>Thanks