Problem in Synchronization PocketPC with SQL Server

From: Anil Babu Vemula via SQLMonster.com (forum_at_SQLMonster.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 05:39:54 GMT

Hi.
I have developed an application using asp Page to subscribe a database in
my Pocket PC with a database in a PC. In my Pocket PC i have SQLCE 2.0. The
PC is running SQL SERVER 2000 and IIS. I have setup the PC as
Publisher. The Pocket PC is connecting to the PC via
ActiveSync3.5 using Serial cable.

The problem is in synchronization.

When the program execute the command of synchronization i
take the Error Message : "..ASP ERROR (80004005)" and the
"Info: refRepl.Initialize "

The ASP Code is:

Sync.asp file

<%

 'Declare the Replication Object.
   'Dim refRepl As SSCE.Replication
   
   ' Create the Replication Object
 
   Set refRepl = CreateObject("SSCE.Replication.2.0")
  ' Dim refRepl As SSCE.Replication

   refRepl.InternetURL = "http://Proserv/Prohats/sscesa20.dll"
   refRepl.InternetLogin = ""
   refRepl.InternetPassword = ""
   
   ' Publisher (SQL Server) info . That is, information
   ' needed for the "ISAPI DLL to SQL Server" connection.

   refRepl.Publisher = "Proserv"
   refRepl.PublisherDatabase = "test"
   refRepl.Publication = "test"
   refRepl.PublisherSecurityMode = DB_AUTHENTICATION

   refRepl.PublisherLogin = "sa"
   refRepl.PublisherPassword = "enter"
   
   ' Subscriber (SQL Server CE) Info. That is, SQL Server CE
   ' database info.

   refRepl.SubscriberConnectionString = "data source=\testabc.sdf"
   refRepl.Subscriber = "SQLCESubscr"
   
   ' Resynch the subscription by calling
   ' the Initialize, Run, Terminate methods
   
   refRepl.Initialize
   refRepl.Run
   refRepl.Terminate
   
   response.write "Sychronize"

   Set refRepl = Nothing
%>

Send me reply as soon as Possible...

Thank in advance... 

-- 
Message posted via http://www.sqlmonster.com

Relevant Pages

  • Re: ms sql ce
    ... I have just started a sample POCKET PC application using Pocket PC 2003 ... I have installed Pocekt PC 2003 SDK, VS.NET, Microsoft SQL Server CE 2.0 on ... I need to have some data on my Pocket Pc Emulator. ... database on SQL Server 2000 which I need to have it on Pocket PC. ...
    (microsoft.public.pocketpc.developer)
  • Re: Are Frontpage passwords secure?
    ... These access a sql server ... > database which has credit cards. ... How does your asp get the credentials for presentation to SQL?? ... If you are using the DB for credit card info, ...
    (microsoft.public.security)
  • RE: ASP Help Needed
    ... Derive the difference, again, using datediff() ... dont touch the database (best practice - if you did a PORPER analisys ... > I need some help with the ASP. ... > I am using MS SQL server 2000 as database ...
    (microsoft.public.inetserver.asp.components)
  • Re: Problem in Synchronization PocketPC with SQL Server
    ... SQL Server CE database on device. ... > my Pocket PC with a database in a PC. ... The Pocket PC is connecting to the PC via ...
    (microsoft.public.sqlserver.ce)
  • Re: Hope this is the correct forum... Question on connection issue
    ... I can say that if I reset SQL Server, I have to re-run everything in Query ... the ASP server quit using them. ... > Our database had been running great for over a year now... ...
    (microsoft.public.sqlserver.server)
Loading