sdf

Connecting to a SQL Server Compact Edition (.sdf) from an MFC application

Hey ! I'm building an MFC app in Visual Studio 2008 which classifies textures and I need some sort of lightweight database to hold the characteristics (just some doubles and strings) which can be: -carried around with the app on different computers; -be able to perform queries on it from the app (searches , updates ,inserts ,etc); Cu...

SQL compact sdf file help with deployment

I am trying to deploy a simple windows forms application using the standard Publish option in Visual Studio. I am using a SQL server compact file (.sdf) as my database. When I deploy the app and install it on a test computer, I get this error: The Path is not valid. Please check the directory for the database. and then it shows me the ...

Problems with executing SqlCeCommand

So I have .sdf database file and such query: SELECT id, name, url, lastSynchronized, synchronizationInterval, fileExtensions FROM pathconfiguration WHERE remote = 1 and (manualSynchronizationRequest = 1 OR (synchronizationInterval IS NOT NULL AND dateadd(minute, synchronizationInterval, COALESCE(lastSynchronized, '1900-01-01')) < GETDAT...