Error with "SqlCeRemoteDataAccess.LocalConnectionString"

[chris-s]

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

 

[Harry Simpson]

<<The variable 'm_DataSource' is set to '\\My Documents\\SantasList.SDF">>
don't you have too many whacks in there? Just guessing.....