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.
Hope these URLs help!
http://support.microsoft.com/kb/920272
and
http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PostID=274359
Thanks,
Laxmi
No comments:
Post a Comment