Emulator Error to replicate data on SQL server

Hi Guys,

I've tried to make Microsoft lab to create a DB(SQL sever CE) on emulator by existing one on SQL Server,but i've a problem :

when i use moethod(of object SqlCeReplication) to make replicate data, emulator send error -2147012867(A connection with the IIS server could not be established)

may you help me,please ?

thx,bye.

Can you connect to IIS virtual directory from emulator? ( http://Computer_name/virtualdirectory/sqlce30.dll ) . You should see a message SQL Server .. Server Agent.

? If you can’t access this, it meant that connection from device/emulator to IIS is broken.

? If you can access this, it meant that there is issue in getting connected /access permission etc from IIS to SQL Server/Publication.

The account you are using for IIS needs to have access on snapshot. If you are using anonymous use IUSR_Computername

Please ensure to give access rights to \\COMPUTER\repldata

check status of snapshot

Select Replicationà Local publicationàpublication you created.

Right click and check the status of snap shot. (Click start if its status was failure)

|||ok,thanks a lot,this problem is done....

but,now i've another problem :

i see server agent message,but i use another way ( http://Computer_name/virtualdirectory/sscesa20.dll ).

When i start appl the same method give me another exception :

"Header information is either corrupted or missing)"

remember,i'm using pocket pc emulator 2003 under VS 2005 beta.

thx for all.
|||

Please excuse us for the late reply.

Here is what my understanding:
1) You are having SQL CE 2.0 Server components on IIS
2) Did you choose Dev App v 1.0 on VS 2005 for the project? I guess you have chosen Dev App (which is SQL CE 3.0 Client). And that is why this error!!

Ok here are the things we want to know to make this proceed further:
1) What is SQL Server version. SQL Server 2000/8.0 or SQL Server 2005/9.0?
2) Where is IIS machine. Same as SQL Server machine or different
3) What is installed on IIS Machine for Replication to work and what versions

The error message generally comes when you have different versions of components in different places.

Also, do you really want to work SQL Server CE 2.0 Client & Server. It is an old version. And, the current version of SQL CE is 3.0. Please consider the option of switching to SQL CE/Mobile 3.0. SQL Mobile 3.0 works very well on Pocket PC 2003. For this you need to choose Dev App.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile

|||

HI,

I am trying to use RDA replication to synchoronize the sql ce 2.0 to SQL 2000 in the desktop in Real PDA..i am getting an error that Header information is missing or corrupted .i am putting my source code below..plzz help me ..its very urgent.

Dim strDBFile As String = "\temp\login.sdf"

_repl.InternetUrl = "http://ihsan/SqlCE/sscesa20.dll"

_repl.Publisher = "IHSAN"

_repl.PublisherLogin = "sa"

_repl.PublisherPassword = "sa"

_repl.PublisherSecurityMode = SecurityType.DBAuthentication

_repl.Publication = "SYNCPDA"

_repl.PublisherDatabase = "SYNCPDA"

_repl.SubscriberConnectionString = "data source=\Temp\login.sdf"

_repl.Subscriber = "SYNCPDA"

If Not System.IO.File.Exists(strDBFile) Then

MessageBox.Show("La aplicacion requiere sincronización" & Microsoft.VisualBasic.Chr(13) & "" & Microsoft.VisualBasic.Chr(10) & "Por favor aguarde", "Replicator", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)

_repl.AddSubscription(AddOption.CreateDatabase)

' sync()

Else

Try

_repl.Synchronize()

Catch ex As Exception

MsgBox(ex.Message)

MsgBox(ex.GetHashCode())

End Try

|||

Are you using a firewall on your desktop, ie Norton. Then see this blog for info: http://dotnetjunkies.com/WebLog/darrenshaffer/archive/2005/12/07/134186.aspx

|||

HI ,

Thanks a lot for your reply,i disabled everyting stiil giving the same error..wat should i do .

Thanks in advance

Regards

Ihsan