Mobile data replication/synchronization

[Marilyn]

Hi,

Could anyone please give me a sample code of the subscriber database's
connection string? I'm getting either a "path not found..." or
"NullReferenceException" errors.

My code goes:
_repl.SubscriberConnectionString = @"Data Source =''.\NfipCeDb.sdf';
Max Database Size = 256; Default Lock Escalation=100";

The local CE database resides in C:\Databases and I'm trying to synchronize
it with the SQL Server.

Thanks for any help.
--Marilyn

[Amit]

you mentioned C:\database as the path,but there is no concept for drive on a
mobile device.
check out this article,hope this helps:
http://msdn2.microsoft.com/en-us/library/aa446539.aspx

--
Thanks and Regards
Amit Ranjan
blog:http://amitranjan.wordpress.com

[Marilyn]

Hi,

Thanks for your response. That was very helpful.
Now, I'm getting an error saying, "An error occurred on the computer running
IIS. Try restarting the IIS Server."

I restarted the IIS on my desktop but the error is still there. Any ideas?
--Again appreciate your assistance.

[Nino Benvenuti]

Marilyn,

In your original e-mail you have a data source of ''.\NfipCeDb.sdf', which
would indicate that your mobile db is on the root of your device; however,
you noted that "local CE database resides in C:\Databases", which is both
contradictory and, as Amit noted, not applicable to Windows CE /Windows
Mobile devices. So, *is* your .sdf on the root of your device?

In regards to your error messages, would you please post the full text of
your error messages (error numbers, too)? Additionally, have you checked the
Event Viewer on the machine running IIS and looked at the System and
Application logs? Or even looked at the IIS logs themselves?

--
Nino Benvenuti
Device Application Development MVP
http://nino.net/blog

"Marilyn" <Mar...@discussions.microsoft.com> wrote in message
news:4CB12705-99E5-4678...@microsoft.com...

[Marilyn]

Hi,

Thanks for responding. Amit set me straight on the Mobile directory for the
mobile database. I revised the code and when I first run my Synchronize
method, it copied the database to the My Documents folder in the device
emulator. So, it's apparently where it should be right now.

After that, this IIS error comes up in the device emulator. Details of the
error says it's a NullReferenceException originating from my synchronization
code.

I looked at the Event Viewer (as you suggested) and the latest log that has
a warning has a "Userenv" source. The information on this event states,
"Windows saved user ServerName\userName registry while an application or
service was still using the registry during log off. The memory used by the
user's registry has not been freed. The registry will be unloaded when it is
no longer in use.

This is often caused by services running as a user account, try configuring
the services to run in either the LocalService or NetworkService account."

I don't know what this is about or how to correct this. Thank you for any
help.

Marilyn

[Marilyn]

Okay; made some revisions. Now the error says, "A request to send data to
the computer running IIS has failed. For more information, see HRESULT."

--Marilyn

[Nino Benvenuti]

There are a variety of reasons that you can receive this message, so if you
can get any of the inner error messages or error codes it would greatly
help.

You also noted that you are using the device emulator; have you verified
network connectivity with the emulator? (Open IE on the emulator and put in
the URL to the IIS box and see if can connect)

Also, what versions of IIS and SQL Server/SQL CE are you using?

--
Nino Benvenuti
Device Application Development MVP
http://nino.net/blog

"Marilyn" <Mar...@discussions.microsoft.com> wrote in message

news:AFB082EB-6C9F-4337...@microsoft.com...

[Marilyn]

Hi, again....

All this time, I tried everything to resolve this "A request to send data to
the computer running IIS has failed" with no luck. So I'm back here one more
time...

My IIS is version 5.1 and I'm using SQL Server 2005/SQL Server Compact
Edition 2.0 SP2. I'm running everything out of my laptop and an emulator.
The funny thing is, I got it to synchronize and replicate several times. But
everytime I thought I got it, the next day when I test it again, it's back to
the same errors -- like it's having a hard time with the IIS. I also can't
get the emulator device to connect to the device Internet when I enter the
URL of the virtual web. However, it's fine when I test it in the local
computer.

I have one unresolved error when I run the SQL Server Mobile Server Agent
Diagnostics: "8.0 Database Reconciler Status: Failure. Error Code:
0x8007007E." I suspect this has something to do with it and I don't know how
to fix this.

Setting up the environment to develop Pocket PC is so frustrating I'm
leaning towards scrapping this entire project altogether.

Any help would be much appreciated.

Marilyn