none
Reg:Error in PULL (RDA) for data sync

    Question

  • Hi Darren & All,

                  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.

    Monday, October 09, 2006 8:47 AM