I'm testing a WPF application that is built on top of a SQL Compact database. SQL Compact seems to be a relatively obscure format that's not supported by a lot of applications, but basically it's a M...
I think that you should look for and install SQL Compact OLE DB Provider and use it instead of SQL Server one like you tried.
I think that you should find the provider using a simple Google request like "sql compact ole db provider". The following links might appear to be useful: