Re: A request to send data to the computer running IIS has failed. NativeError 28037

I have no third party security software installed and disabled the Microsoft
firewall.

I can delete the database and re-created it with this line of code no
problem.
_sqlCeReplication.AddSubscription(AddOption.CreateDatabase);

I can even create the subscription on the mobile db via SQL Server
Management Studio (SMS) and synchronize with SMS with no problems.


It fails the first time on:
_sqlCeReplication.Synchronize();

I have tried to just use the subscription that was created via SMS though
code (AddOption.ExistingDatabase) and it fails. I know it exists because if
I try to create the subscription I get the "Subscription already exists"
error.

Thanks for the help.
Brian K. Williams






"Alberto Silva - Mobile Devices MVP"
<albertosilva@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1DEE625F-5AF0-4D01-B0AE-FF3FDB6063E1@xxxxxxxxxxxxxxxx
Hi Brian,
If possible, disable completelly or even uninstall 3rd party security
software, and try again.

When does the error happen, on the 1st synchronization, or just after
creating some records on the device side?

--

Alberto Silva
Mobile Devices MVP @pt
http://msmvps.com/AlbertoSilva

"Brian Williams" <williamsb@xxxxxxxxxxxx> wrote in message
news:%23jeBaTFOHHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
I am not to this stage yet, still working only in Visual Studio 2005 Debug
mode with SQL and IIS on the same system. I also tried it with SQL and IIS
on a separate system running Server 2003.

I fogot to mention, I have turned off the firewall on both systems.

Thanks
Brian K. Williams


"Alberto Silva - Mobile Devices MVP"
<albertosilva@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B3BD4E3F-7553-4035-89A6-35613898675F@xxxxxxxxxxxxxxxx
(copy&paste from a previous reply about the same issue)

Does the error happen only when synching using GPRS? Can you test with
other
remote options, like WiFi, to check if the error only happens with GPRS?

If so, try with a different mobile operator, and if you reach the
conclusion
that it only happens synching with GPRS on one particular mobile
operator,
contact them to know if they have implemented some changes on their
network,
like installing some kind of security or compression tools, and if there
is
a way to avoid them.

Here in Portugal, we had a customer who had that problem, that was fixed
using a different username provided by Vodafone to establish the GPRS
connection.

----

About your particular situation, if your are tryng to sync locally, try
disabling firewalls, antivirus and other internet security software.

--

Alberto Silva
Mobile Devices MVP @pt
http://msmvps.com/AlbertoSilva

"Brian Williams" <williamsb@xxxxxxxxxxxx> wrote in message
news:%23esllJoNHHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
I have installed the the following Microsoft SQL Server 2005 Compact
Edition files: (Released 11 Jan 2007)
Microsoft SQL Server 2005 Compact Edition Server Tools.msi
Microsoft SQL Server 2005 Compact Edition Developer Software
Development Kit.msi
Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005
Service Pack 1.exe
Microsoft SQL Server 2005 Compact Edition.msi

I have created a publication (SQL Server 2005) and subscription (SQL
Server Mobile 2005) via SQL Server Management Studio (SMS). I can
connect to my SQL Server Mobile database in SMS and syncronise
subscriptions with no problems.

I can at any time run http:// My IP Address/ Virtual Directoy Name
/sqlcesa30.dll in my browser and get back:
"SQL Server Mobile Server Agent 3.0"

When I run the CE 5 Project in debug mode against SQL Server and IIS on
the same box, I get Native Error 28037.
When I run the CE 5 Project in debug mode against SQL Server and IIS on
a diferent Windows 2003 server I get the same Native Error 28037.

This is my code:










.

Relevant Pages

  • Re: A request to send data to the computer running IIS has failed. NativeError 28037
    ... "Alberto Silva - Mobile Devices MVP" wrote in message ... About your particular situation, if your are tryng to sync locally, try disabling firewalls, antivirus and other internet security software. ... Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit.msi ...
    (microsoft.public.sqlserver.ce)
  • Re: Help for sql server
    ... You may be referring to "Microsoft SQL Server 2005 Everywhere Edition", ... MS Mobile Devices MVP ...
    (microsoft.public.sqlserver.ce)
  • RE: Sharepoint issue
    ... do you mean Microsoft SQL Server ... 833183 You receive a "Cannot connect to the configuration database" error ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • CERT Advisory CA-2002-22 Multiple Vulnerabilities in Microsoft SQL Server
    ... The Microsoft SQL Server contains several serious vulnerabilities that ... These vulnerabilities are public and have ... the same privileges as the operating system. ... a compromised Microsoft SQL Server can be used to take ...
    (Cert)
  • RE: Update Windows XP Home SP2
    ... I have tried many times unsucessfully to install the Microsoft SQL Server ... Download Center. ...
    (microsoft.public.windowsupdate)