I am running SQL Server 2005 Express. There is a third party app on the system that uses Microsoft SQL Server Compact Edition (using a file with an .SDF extension)
Is it possible for me to point to this as a linked server within SQL Server Management Studio? If so, how? I see no "Compact Edition" in the list of datasource types when trying to setup the linked server.
Additionally, if not, is it possible to set it up as an ODBC source?