Describes how to connect to Microsoft SQL Server Compact Edition .
Currently, AnyDAC version 5.0 does not have a native Microsoft SQL Server CE driver, but you can use the AnyDAC/DBX Bridge driver to connect to Microsoft SQL Server CE.
Note: Microsoft SQL CE is quite different from normal SQL Server's and doesn't have an ODBC driver. So it won't "just work" with the same AnyDAC Microsoft SQL driver code base. New R&D will need to go into supporting Microsoft SQL CE in full.
For now though, you can work with database via the AnyDAC/DBX Bridge. Working via the AnyDAC/DBX Bridge, you still will be able to use all other general AnyDAC features, like:
To connect to Microsoft SQL CE, do the following:
[My_MSSQL_CE] DriverID=TDBX DriverName="SQLServer Compact" Database=c:\mydb.sdf
What do you think about this topic? Send feedback!