>>>OK, thanks. Do you know if the 32bit VFPOLEDB driver can be used from within a 64bit application ?
>>
>>No, 64 bit application uses 64bit OLE DB
>>
>
>Thanks Martina - I guess there is no way around it ?

Eh, check Advantage OLEDB driver (without warranty).

or

Will be crazy...
- MSSQL Express 32 bit
- enable 'Ad Hoc Distributed Queries'
- grant execute xp_prop_oledb_provider
- add linked server to DBF (VFPOLEDB driver 32bit)
- add synonym for each dbf example: CREATE SYNONYM vfptable FOR VFP_LINK..vfptable

- change connectstring from VFP to MSSQL in 64bit application


MartinaJ

>
>
>
>>
>>>
>>>>You give your application the connection string. Anytime I need connection string info, I go to www.connectionstrings.com.
>>>>
>>>>>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.