RDA with MSDE?

  • Thread starter Thread starter LawX
  • Start date Start date
L

LawX

I'm experiencing troubles while using RDA. It's now been
three days I try to debug the application but there's
nothing to do with it. So my question is, quite basic
actually, can I use RDA with an MSDE based DB instead of a
classical Sql Server? I guess I should have asked myself
this question a long time ago, especially if it is not
possible !! :-(

Thanks for helping, if you have any article or guides on
the subject, i'll be very pleased.
 
Ok forgot about all that, I made it on my own....and it
works!!!! At last.
So, I know can tell that are no troubles using MSDE for
RDA.
Ok, we'll surely meet again as I know have to develop the
whole application.

see ya all

LawX (living a hopefull moment of life)
 
Actually, they are exactly the same as for a classic Sql
Server.
You first have to configure all the security doors (IIS,
MSDE, Internet).Use the SQL Server CE Connectivity
Management.msc to configure all the MSDE stuff. I can tell
you you'd better use anonymous access for the HTTP
authentication, it's seems more simple if you work with a
network-connected station and you're not sure of the
authorization given by your MS login/pwd.

I can give you a sample of my code but it is as simple as
all the example you can find:

SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();
string
SqlRemoteDataConnStr = "Provider=sqloledb;Data
Source=127.0.0.1;Initial Catalog=LAW;integrated
security=SSPI"; //that string connects to the SqlSvr. Mine
is on my local station.

rda.InternetUrl =
@"http://134.??.??.41/lawrence/sscesa20.dll"; //IP or
server name / virtual directory on IIS / SqlCeServer Agent

rda.LocalConnectionString = "Data Source=" + DBPATH;

try
{
rda.Pull("TYPE", "select * from TYPE",
SqlRemoteDataConnStr,
RdaTrackOption.TrackingOn, "rdaTypeError");

rda.Pull("CLE", "select * from CLE", SqlRemoteDataConnStr,
RdaTrackOption.TrackingOn, "rdaCleError");
.....
}
catch(SqlCeException ex){...}


There you are, hope it helps.

see ya.
LawX
 
Back
Top