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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top