As far as I know there's no ODBC driver for SQL Server CE, but there is OLEDB,

>Just curious: Have you tried accessing SQL Compact from VFP? What do you need for this to work?
>
>Client Drivers? ODBC Drivers? i'd be surprised if there even were non-managed drivers for SQL Compact...
>
>+++ Rick ---
>
>>SQL Server Compact Edition. You can XCopy deploy that. http://msdn.microsoft.com/en-us/data/ff687142
>>
>>>Anyone have any experience using VFP and sqlite? I have a small app (7 tables), and something bigger than sqlite seems like overkill.
>>>
>>>If so, suggestions would be appreciated.