SQL Merge Replication Problem

B

Butt Chin Chuan

Hello everyone!

I'm sorry for giving trouble to you ppl with this request,
but I really at my wits end. I am using the Microsoft .Net
Compact Framework Core Reference by Andy Wigley and
Stpehen Wheelwright. I am facing some problems with
setting up a replication applcation, even by using the
sample in the book. The following are my problems, which I
hope you can kindly help me out, as I need an application
done by tomorrow around 16 hours from this message:

1) The first problem crops out when I want to make a
snapshot of the Traffic database in the sample. I got the
warning that I will need adaminstrative rights to to merge
and/or push/pull later on if I use the default path. How
come? When I tried to change my path to something else, I
got the error message invalid path. What's the problem
here?

2) Secondly, after I created the snapshot, I tried to run
the sample application of the book, TrafficMR. Now, this
is the following code I used:
Dim rep As SqlCeReplication = New SqlCeReplication( _
"http://butt2000/TrafficMR/sscesa20.dll", _
"", "", _
"Butt2000\Butt2000", _
"Traffic", _
"MyLoginName", _
"MyPassword", _
"Data Source=\My Documents\TrafficMR.sdf")
The sample here says it uses the Windows authentication,
but I use SQL authentication. Can you please kindly tell
me where to change the settings or the parameters?
3) I got the following error messages when I try to load
the application, since it automatically loads the merge
function on start up:
Index #0
Microsodf SQl Server 2000 Windows CE Edition
Error: Authentication failed on the computer running IIS,
[,,,,,]
I know this error message seems too general, but I really
don't know what to do with this error. I suspect I missed
out something in the settings or parameters in (3) since I
used SQL authentication.

4) Last but not least, if it is not too much trouble for
you, can you kindly list out the steps needed and a simple
code for me to retrieve my merged database? I can then
refer and modify from there. There are some samples in the
internet, but I can't really understand them properly,
hopefully i can get an explaination from you which clears
up my misunderstanding.

Thank you very much.
 
C

C. Vollmer

Hi,

take a look at Google Groups in the newsgroup
microsoft.public.sqlserver.ce. There are a lot of informations regarding
these problems.

Christoph
 
B

Butt Chin Chuan

Thanks, still looking at it, hopefully can solve my
problem ASAP. :)
-----Original Message-----
Hi,

take a look at Google Groups in the newsgroup
microsoft.public.sqlserver.ce. There are a lot of informations regarding
these problems.

Christoph
Hello everyone!

I'm sorry for giving trouble to you ppl with this request,
but I really at my wits end. I am using the Microsoft .Net
Compact Framework Core Reference by Andy Wigley and
Stpehen Wheelwright. I am facing some problems with
setting up a replication applcation, even by using the
sample in the book. The following are my problems, which I
hope you can kindly help me out, as I need an application
done by tomorrow around 16 hours from this message:

1) The first problem crops out when I want to make a
snapshot of the Traffic database in the sample. I got the
warning that I will need adaminstrative rights to to merge
and/or push/pull later on if I use the default path. How
come? When I tried to change my path to something else, I
got the error message invalid path. What's the problem
here?

2) Secondly, after I created the snapshot, I tried to run
the sample application of the book, TrafficMR. Now, this
is the following code I used:
Dim rep As SqlCeReplication = New SqlCeReplication( _
"http://butt2000/TrafficMR/sscesa20.dll", _
"", "", _
"Butt2000\Butt2000", _
"Traffic", _
"MyLoginName", _
"MyPassword", _
"Data Source=\My Documents\TrafficMR.sdf")
The sample here says it uses the Windows authentication,
but I use SQL authentication. Can you please kindly tell
me where to change the settings or the parameters?
3) I got the following error messages when I try to load
the application, since it automatically loads the merge
function on start up:
Index #0
Microsodf SQl Server 2000 Windows CE Edition
Error: Authentication failed on the computer running IIS,
[,,,,,]
I know this error message seems too general, but I really
don't know what to do with this error. I suspect I missed
out something in the settings or parameters in (3) since I
used SQL authentication.

4) Last but not least, if it is not too much trouble for
you, can you kindly list out the steps needed and a simple
code for me to retrieve my merged database? I can then
refer and modify from there. There are some samples in the
internet, but I can't really understand them properly,
hopefully i can get an explaination from you which clears
up my misunderstanding.

Thank you very much.

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top