<chris-s@mailcity.com> wrote in message
news:cab24464-3a27-4b03-abb3-399e7a52a59b@s12g2000prg.googlegroups.com...
> I'm in the process of upgrading an application from VS2003/SQLCE2.0 to
> VS2008/SQLCE3.5
>
> The conversion seems to have gone fine, and the application is built
> and deployed, but I am getting the following error when I try to set
> the SqlCeRemoteDataAccess.LocalConnectionString...
>
> "Unknown connection option in connection string: provider."
>
>
> Code snippet :
>
> SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();
> rda.InternetUrl =
> ConfigurationSettings.AppSettings(Config.InternetUrl,"");
> rda.InternetLogin =
> ConfigurationSettings.AppSettings(Config.InternetLogin,"");
> rda.InternetPassword =
> ConfigurationSettings.AppSettings(Config.InternetPassword,"");
>
>
> // rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.
> 2.0;Data Source=" + m_DataSource;
>
> rda.LocalConnectionString =
> "Provider=Microsoft.SQLSERVER.OLEDB.CE.3.5;Data Source=" +
> m_DataSource;
>
>
> The variable 'm_DataSource' is set to '\\My Documents\\SantasList.SDF"
>
> I have deployed the SQLCE 3.5 dll's and the SDF has been created with
> these dll's and I have verified that it is a 3.5 version.
>
> Any suggestions?
>
> Cheers
>
> Chris