fail to connect to sql server 2000 using emulator 4.2

  • Thread starter Thread starter stone zou
  • Start date Start date
S

stone zou

hi:
i use the VS2003, WinCE Emulator4.2 , IIS, SQL Server 2000
IIS security used the anonymous login.


My code is :
DBPath = shellui.sqlcewrapper.LocalDatabase;
lconnstr = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" +
DBPath + "; Password = 123;";

//Create replication object and initialize it
SqlCeReplication sscerepl = new SqlCeReplication();
sscerepl.InternetUrl=URL.Text; //URL of the server agent
sscerepl.InternetPassword = "liuwenhua"; //credentials for the IIS
directory where the server agent resides
sscerepl.InternetLogin ="IUSR_CPULICHWEILIU";
sscerepl.Publisher=SQLServer.Text; //publisher
sscerepl.Publication = "contact"; //name of the publication
sscerepl.PublisherDatabase = "truetel"; //name of the published DB
sscerepl.PublisherLogin = user.Text; //credentials for the DB/PAL
(publication access list)on server
sscerepl.PublisherPassword =password.Text;
sscerepl.Subscriber = "SQLCE_Client"; //name of the client device
(optional)
sscerepl.SubscriberConnectionString = lconnstr; //conn string for the
local SQLCE DB
sscerepl.AddSubscription(AddOption.CreateDatabase);


the return error code is:
native error: 28037
message: a request to send data to the computer running IIS has fialed.
for more information, see HRESULT.[,,,,,]
Source:Microsoft SQL Server 2000 Windows CE Edition
 
Hi,

This can happen for instance if IIS is stopped.

Alfred Gary Myers Jr.
Yuma Informática Ltda.
 
28037 can be returned when the IIS server is not running, or the URL is
incorrect.

Verify that you can connect from your device to the IIS Server by pinging
the URL from PocketIE. If you can get "SQL Server CE Server Agent"
returned from the SQL Server CE Server Agent, then you should be able to
complete a sync.

If you cannot, then you need to verify that your URL is correct, the IIS
Server is up and running.

Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: "Alfred Gary Myers Jr." <[email protected]>
References: <[email protected]>
Subject: Re: fail to connect to sql server 2000 using emulator 4.2
Date: Wed, 3 Dec 2003 18:21:47 -0300
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: 200.144.29.2
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:40124
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Hi,

This can happen for instance if IIS is stopped.

Alfred Gary Myers Jr.
Yuma Informática Ltda.


stone zou said:
hi:
i use the VS2003, WinCE Emulator4.2 , IIS, SQL Server 2000
IIS security used the anonymous login.


My code is :
DBPath = shellui.sqlcewrapper.LocalDatabase;
lconnstr = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" +
DBPath + "; Password = 123;";

//Create replication object and initialize it
SqlCeReplication sscerepl = new SqlCeReplication();
sscerepl.InternetUrl=URL.Text; //URL of the server agent
sscerepl.InternetPassword = "liuwenhua"; //credentials for the IIS
directory where the server agent resides
sscerepl.InternetLogin ="IUSR_CPULICHWEILIU";
sscerepl.Publisher=SQLServer.Text; //publisher
sscerepl.Publication = "contact"; //name of the publication
sscerepl.PublisherDatabase = "truetel"; //name of the published DB
sscerepl.PublisherLogin = user.Text; //credentials for the DB/PAL
(publication access list)on server
sscerepl.PublisherPassword =password.Text;
sscerepl.Subscriber = "SQLCE_Client"; //name of the client device
(optional)
sscerepl.SubscriberConnectionString = lconnstr; //conn string for the
local SQLCE DB
sscerepl.AddSubscription(AddOption.CreateDatabase);


the return error code is:
native error: 28037
message: a request to send data to the computer running IIS has fialed.
for more information, see HRESULT.[,,,,,]
Source:Microsoft SQL Server 2000 Windows CE Edition
Click to expand...
 
Back
Top