Is it possible to create an SDF file that is compatiable with SQL Server CE 2.0, on a desktop language using ADO and Visual FoxPro ? Ideally I am looking for an OLE DB Provider on a desktop to do this, but I am not sure if its possible ?
I have successfully created a SDF database on PC using the Microsoft.SQLSERVER.CE.OLEDB.3.5 provider and that works fine.
Whenever I change my code to use "Microsoft.SQLSERVER.CE.OLEDB.2.0" it displays an error OLE IDispatch exception code 0 from Microsoft OLE DB Service Components: Class not registered.
I need to use SQL Server CE 2.0 as it is a legacy application I am working with so it has to be in this format.