I'm unfortunately well aware from extensive reading that SQL Server Compact 4 can no longer be opened as an object in SQL Server 2014 Management Studio.
However I can't find any definitive information on whether or not I can add
Microsoft.SQLSERVER.CE.OLEDB.4.0 as a provider in SQL Server 2014.
My intention is to automate data extraction from a number of SQL Server Compact databases using
OPENROWSET - I already have a similar automation process in place to open Visual FoxPro DBF files with the
It seems beyond belief that I can access an archaic database format via this method but not SQL Server Compact 4.