New to CF + SQL CE - Please Help

  • Thread starter Thread starter Simone
  • Start date Start date
S

Simone

I am trying to run the IBUYSPY sample application on the emulator, RDA works
fine, but I am getting two errors if I select replication:

Initializing sql server reconciler has failed
The remote server does not exist or has not been designated as a valid
publisher

I'm using the server's IP address instead of DNS because somehow it can't
resolve the DNS name. So I enter in the IP address in the box.

If I go to the URL path to sscesa20.dll I get the "SQL Server CE Agent"
screen.

Environment:
SQL Server SP 3
VS 2003
Pocket PC 2002 Emulator

Could anyone help me please?
 
Thanks for replying, Alex.
Yes. I'm using my computer's IP address (10.244.25.67)
I've just tried 127.0.0.1, it doesn't work in Internet Explorer, neither in
IBuySpy.
I'm able to connect to the internet from the emulator, if that helps.
 
Hi Simone,

By your error, replication managed to reach past the IIS Server share. Make
sure all of the Replication scripts ran fine and that your snapshot
directory for replication is accessible from your emulator. Also make sure
that the Sql Server Agent is running and created the snapshot.
 
I can open the snapshot directory from the emulator if I enter my domain
name/ password.
But the snapshot folder is empty. There's nothing in there.
I gave everyone full control to the snapshot folder + network permissions.
Sql Server Agent is running.
How do I check if the replication scripts ran fine?
 
In Enterprise Manager, under Replication Monitor/Publishers, originally
there was my computer dns name.
If I add my IP Address 10.244.25.67 as a new publisher, then I get a
different message saying publication doesn't exist.

Initializing Sql server reconsiler has failed
Followed by:
Publication 'StoreSample' does not exist.

And a new folder (UNC) is created under the snapshot
folder:C:\SNAPSHOT\unc\0031660-51723-2_Store_StoreSample\20030820114532.

So I am wondering if this is a DNS problem.
 
Alright, finally realized what was wrong.
Somehow Server name is not the same as Publisher name.
I entered the ip in the server name box.
But I made one change in the IBUYSPY code:

repl.Publisher = "putyourdnsnamehere"

It didn't like the IP address that was being passed before.

Thanks all!
 
Back
Top