Data Source should be set to your .sdf file. AFAIK you can't just connect to a specific table, you have to connect to a database.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlservercesqlceconnectionclassconnectionstringtopic.asp


>Hello,
>
>I seem to be having a problem with this connection string.
>
>SqlCeConnection ceConn = new SqlCeConnection();
>ceConn.ConnectionString = "Persist Security Info=False;
>Source = C_Quest.dbo.Orders" +
>"Password = ; server=NYC1;Connect Timeout=30";
>
>Where is the error? I cant see it..
>
>Thanks,
>
>Alvin