Potential Memory Leak with DataSet ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Cube (anonymous_at_discussions.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 08:46:02 -0700

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

Relevant Pages

  • RE: SQL Backup to SAN with DoubleTake Replication
    ... > database while backing up. ... > replicating the backup file that is curently backed up by ... > the SQL server, then your server will go south-north and ... > Double-Take meant to replicate the database that is ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Backup to SAN with DoubleTake Replication
    ... > database while backing up. ... > replicating the backup file that is curently backed up by ... > the SQL server, then your server will go south-north and ... > Double-Take meant to replicate the database that is ...
    (microsoft.public.sqlserver.server)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • SQL Backup to SAN with DoubleTake Replication
    ... Double-Take does not get effected when the database is ... replicating the backup file that is curently backed up by ... the SQL server, then your server will go south-north and ...
    (microsoft.public.sqlserver.server)