>>>Yes to both. I am just looking for an example of using OLEDB from any app so that I can see what the connection parameters and steps should be. Then I can experiment from my app. Thanks.
>>>
>>>>Step 1... Does the other application support OLEDB?
>>>>Step 2... If step one fails, does the other application support ODBC?
>>>>
>>>>>Hi All,
>>>>>
>>>>>How do I use the OLEDB provider for VFP from another application so that the other app can open and read a DBF file? Haven't done this before. I assume one needs to set up a connection somehow?
>>>>>
>>>>>TIA
>>
>>Here is one sample I found by a quick search, you can find more by googling on 'VFPOleDB'
>>
>>Re: Accessing VFP data Thread #1550761 Message #1550817
>
>Thanks Naomi. Busy searching. Do you know if the VFPOLEDB can be called from a 64 bit application ?

I know there are some challenges of using VFP data from SQL Server 64 bit. I have a blog on this topic

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wan