Skip to content

Microsoft SQL Compact Edition Connections

Jump to bottom
Peter Gill edited this page Oct 9, 2026 · 8 revisions

Legacy — v4 / .NET Framework only. SQL Server Compact Edition is not supported in 26.x. For current SQL Server connectivity see SQL Server Connection.

How to connect to MS SQL Server Compact Edition in the "New Report from Database" wizard, on the Connection tab.

Using the new connection wizard. In the designer click the new report wizard. When you get to the connection tab for the connection type select "SQLce". Enter the connection string you need and click "Test Connection". Once the connection is working you can use continue creating your report.

Simple Connection String

Data Source=C:\ThePathToYour\Database.sdf;Persist Security Info=False;

Microsoft SQL Compact Edition Connection

Note that this requires the SQLce data provider exists in the RdlEngineConfig.xml file.

Clone this wiki locally