Problems with SQL CE and IIS

[Stig]

I am working on something that will take data from a SQL2000 database that is running on the same computer as the one that runs the IIS but when i try and run the Pull function(and Push and submitsql for that matter) i get and error and from looking at the HResult and converting etc the error that it tells me is
ERROR_INTERNET_CONNECTION_RESET (INTERNET_ERROR_BASE + 31)
i have tested the setup and if i go to the pda internet explorer i can access that sql ce agent page no prob and all the other pages running on the IIS (i did it by using "http://<IPaddress>/<setupfolder>/sscesa20.dll")
does any one know how i can solve this problem??

[JasonLJames]

I had similar problems with the entire issue of replication, but it seems to be ones of those areas that doesn't attract too much in the ay of help. It is a very complex topic. Have you tried the archieved news groups on google : http://groups.google.com . There is a lot of good stuff there.

Good luck and let us know how you get on.

Regards,

Jason

[Stig]

That problem has seemed to pass now but the next error that i get is native error 28574 and it seems to be a sql server ce client agent error the hresult error nuber is 80004005 but i can't seem to translate it into a number that i can use to search for the error.

It says "Internal error occured (ID,,,,,)"

Does any one hav an idea how i can fix this problem??


JasonLJames what did you do to solve your problem???

[JasonLJames]

Stig,

my error, although I am embarrassed to admit it, was a simple typo error. Once I had IE talking to IIS and the virtual folder, and I could access the DB as the user I created (I checked this with QA on my desktop) everything appeared to fall into place. The big problem was table and field names not being typed correctly, and the folder locations of the IIS and SQL parts of the publication not being typed correctly in my PPC application.

Post your code here and I will try and take a look to see if there is anything that I can suggest.

Jason.