Hi Everyone,

I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database".

string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANA\PRASANNA;Password=master";

qlCeRemoteDataAccess rda = null;

try

{

rda = new SqlCeRemoteDataAccess();

rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf";

rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll;

rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn);

MessageBox.Show("Completed");

please guide me any one ours guys to solve this problem .

Thanks

Prasanna.

A few problematic things I see here in your code:

1. try Provider=SQLOLEDB (not sure why you have .1 suffix on there)

2. the InternetURL must be in quotes and cannot be localhost - it should be http://{ipAddressOfYourServer}/{virtualdirectoryName}/sqlcesa30.dll

3. do you really mean to try to push a table into the master database? your intial catalog in the connection string indicates that this is your intention

4. you cannot push until you pull with tracking on

Darren

Hi Darren,

Thanks! As per your guidance, i have tried in the pull method.Now i am getting error "The LocalTablename parameter is already specified".

Coding as follows:

string rdaOleDbConnectString = @"Provider=SQLOLEDB; Data Source=PRASSANA\PRASANA;Initial Catalog=master;User Id=sa;Password=master";
SqlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=E:\\SampleTest.sdf";
rda.InternetUrl = "http://192.168.1.118/TEst/sqlcesa30.dll";
rda.InternetLogin = "IUSR_PRASSANA";
rda.InternetPassword = "PRASSANA";
rda.Pull("company", "Select * from company", rdaOleDbConnectString, RdaTrackOption.TrackingOn);
MessageBox.Show("Pull Method");
}
catch (SqlCeException)
{
Message.show(ex.message);
}
finally
{
// Dispose of the RDA Object
//
rda.Dispose();
}
}
Please guide me in detail, what mistake i have done in this method.

Thanks ,

Prasanna.