Don't use an ODBC connection, use an SqlCeConnection instead:
using (SqlCeConnection con = new SqlCeConnection(ConnectionString))
{
con.Open();
using (SqlCeCommand cmd = new SqlCeCommand("SELECT iD, userName FROM MyTable", con))
{
SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
da.Fill(dt);
}
}
You may need to download it first (
http://www.microsoft.com/en-us/download/details.aspx?id=5783[
^]) and add a reference to "System.Data.SqlCE.dll"