Upload data to SQL Server 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've been googling for some time and searched this forum for an answer
that I didn't find, so I'll have to post a new one.

I'm trying to upload changes from a SQL Server CE database to SQL Server
2000 using VB.net. The rows that I insert show up at the SQL CE, but when I
call the uploading function it just doesn't work. The code looks like this
(just like almost every example I found):

Dim rep As New Data.SqlServerCe.SqlCeReplication ('arguments
work right for downloading, so they should be ok for uploading too)

Try
rep.ReinitializeSubscription(True)
rep.Synchronize()
Catch ex As Data.SqlServerCe.SqlCeException
Throw ex
Finally
rep.Dispose()
End Try

When I call it after an insert, this thing just downloads the server data
without uploading the client changes first as it should. I tried using upload
only exchange type, and then nothing happened. No exception is raised.

If you can post an example or a link to someplace I can find the answer it
would be great, I need this solved ASAP or my boss will kill me! ;) Thanks a
lot
 
Back
Top