Re: Potential Memory Leak with DataSet ?

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/27/04 

Date: Thu, 27 May 2004 15:47:30 -0400

Are you sure that Step one is completing properly? If they are saving to CE
correctly and you are sure of this, then are you positive that you aren't
getting any errors in replication?

I do this every day and know a lot of other folks who do and while there are
some potential problems if things aren't done correctly, i've never heard of
a memory leak in a dataset and don't see how, even if there was one, that
this would be the symptom.

Let me know though and hopefully we can get through it. 

-- 
W.G. Ryan, eMVP
"Cube" <anonymous@discussions.microsoft.com> wrote in message
news:0D96D49C-B76D-413B-A367-F36DA9999BD7@microsoft.com...
> Hi all,
>
> I have a PocketPC 2003 device running SQL CE, and merge replicating with
SQL Server 2000.
> The size of the database is around 2MB on my device.
>
> When I launch my CF app for the first time. (e.g. after a soft-reset) all
the data from
> the database is loaded into my dataset and my dataset is bound to the
various controls
> on my app. (I use show/hide panels not multi-forms). Once a day I sync the
data back
> to the server (around 300 records). This involves:
>
> 1. Save Dataset to the Database
> 2. Replicate Database with the Server Database (Merge Replication)
> 3. Load updated database back up into the dataset
> 4. Rebind the dataset to the controls.
>
> Lately I've found that some records are never getting into my database and
sometimes
> my controls have no data in them after a sync. I'm thinking it could be a
memory leak
> in my app./ dataset is screwed as this seems to happen after a prolonged
period of time.
> Has anyone any ideas?
>
> Thanks for the help
http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp

Relevant Pages

  • Re: Publishers disappeared from under replication monitor
    ... Basically the only database on the server being replicated suddenly had 'no' ... This seemed like some kind of corruption in the database. ... The next day we set up transactional replication again (Yes, ... > distribution agent name you can get a condition like this. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscriber Transaction Logs Too Large
    ... mentioned not shrinking the file too much on SQL 2000. ... SQL 2005 (Server B). ... alter database databaseName ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)