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:

• data type mapping
• Array DML
• SQL scripting
• etc.

To connect to Microsoft SQL CE, do the following:

• Download and install DevArt dbExpress driver for Microsoft SQL Server.
• Create a connection definition, like this one:

[My_MSSQL_CE]
DriverID=TDBX
DriverName="SQLServer Compact"
Database=c:\mydb.sdf

• Drop TADConnection to the form
• Set ADConnection1.ConnectionDefName to My_MSSQL_CE

Common connection parameters, FAQs, How to configure AnyDAC Drivers, How to manage AnyDAC Connection Definitions