Click here to Skip to main content
15,885,944 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi,

I have a problem.

I want to use RDA (Remote Data Access). But I don't know anything
about sscesa35 :(

I find sample on msdn for this subject.
string rdaOleDbConnectString = "Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUser;Password=MyPassword";
SqlCeRemoteDataAccess rda = null;
try
{
    rda = new SqlCeRemoteDataAccess();
    rda.InternetLogin = "MyUser";
    rda.InternetPassword = "MyPassword";
    rda.InternetUrl = "http://www.adventure-works.com/sqlmobile/sqlcesa35.dll";
    rda.LocalConnectionString = @"Data Source=\Program Files\SmartDeviceProject8\ssce.sdf";

    rda.Pull(
        "Table",
        "Select * from Table",
        rdaOleDbConnectString,
        RdaTrackOption.TrackingOnWithIndexes,
        "ErrorTable");
}
catch (SqlCeException ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    rda.Dispose();
}


this code be http error. Because I don't configure IIS 7 with SQL Server Compact 3.5

Please help me :(
Posted
Updated 25-Feb-10 20:37pm
v6

1 solution

Hi friend don't worry am giving u link this will be helpful for u
http://msdn.microsoft.com/en-us/library/bb226707%28SQL.90%29.aspx[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900