Connect to MS SQL Server Compact Edition (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.


General

Currently, AnyDAC version 2.0 does not have a native MS SQL Server CE driver, but you can use the AnyDAC/DBX Bridge driver to connect to MS SQL Server CE.

Note that MSSQL CE is quite different from the normal SQL server and does not have an ODBC driver. So it won't "just work" with the same AnyDAC MSSQL driver code base. New R&D will need to go into supporting MSSQL CE in full.

For now though, you can work with DBMS via the AnyDAC/DBX Bridge (needs AnyDAC 2.0.1.283 or later).

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

Connect using AnyDAC/DBX Bridge

To connect to MSSQL CE do the following:

  • Download and install CoreLab dbExpress driver for MSSQL
  • Create a connection definition, like this one: 

[My_MSSQL_CE]
DriverID=TDBX
DriverName="SQLServer Compact"
Database=c:\mydb.sdf
  • Drop TADDatabase to the form
  • Set ADDatabase1.ConnectionDefName to My_MSSQL_CE


See Also


Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_MS_SQL_Server_Compact_Edition_%28AnyDAC%29"
Personal tools