Delphi 5 + Win 2K

From: qswami (qswami_at_rediffmail.com)
Date: 08/23/04

  • Next message: Mark A. Deal: "Re: Select Max with Access" 
    Date: 23 Aug 2004 07:38:43 -0700

    Hello all,

    We have a windows application developed using Delphi 5 + ADO and MS SQL Server 2000. In one of the parts of the application, we try to import data (if this info reqd. - this is basically an output of a another system and it is in CAM system format, typically a ODB format). The data is loaded in to a Tree component. (We use a third party Tree component here). When the same is saved to the data base it is compressed before saving using another third party tool, since the data saved can be quite as big as 7MB. When the user wants to view the data, the same steps are done in the reverse order, ie., get the data from the database, uncompress it using the same 3rd party tool used for compression, and load it to the tree component.
    The datatype in the database is IMAGE.

    Now, coming to the problem, when doing this process for several times randomly, the data saved to the database gets corrupted ie., it becomes of invalid format and cannot be
    reloaded and used again. To resolve this intially we tried to remove all the third party component and dependencies, but the problem seems to persist. So, could it be due to some memory constraints of the system based on the following observations.
       The number of page faults in the windows Task Manager shows a big number and
       If the database is cleaned up by deleting many jobs it seems to work without any issues until at some point it starts showing up again regularly.

    If it could be due to memory issues, any tips / ideas / suggestions to resolve this are most welcome.

    Thanks,
    qswami

  • Next message: Mark A. Deal: "Re: Select Max with Access"

    Relevant Pages

    • Re: Unable to get global configuration data.
      ... "SharinDenver" wrote: ... how to resolve the default website. ... on the web server. ... Unable to connect to database. ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: User Rights Assignment - not available
      ... To resolve this issue, first run the Esentutl.exe tool to examine the ... and WinDir is the folder where Windows XP ... This operation may find that this database is corrupt ... Initiating INTEGRITY mode... ...
      (microsoft.public.windowsxp.security_admin)
    • Re: Cant Install SP4 for SQL 2000 / Win2k3
      ... This explains why a reinstall did not fix the errors. ... ran 'sp_resetstatus msdb' from query analyzer, ... > The LSN %S_LSN passed to log scan in database '%.*ls' is invalid. ... > To resolve this problem, obtain the latest service pack for Microsoft SQL ...
      (microsoft.public.sqlserver.setup)
    • Re: User Rights Assignment - not available
      ... To resolve this issue, first run the Esentutl.exe tool to examine the ... and WinDir is the folder where Windows XP ... This operation may find that this database is corrupt ... Initiating INTEGRITY mode... ...
      (microsoft.public.windowsxp.security_admin)
    • Re: Statistic Generator
      ... About your only option, short of implementing auditing in your SPs and adding triggers to the tables (to monitor i/u/d access) is to use Profiler or server-side tracing and watch activity, say over a 24-hour period. ... You can resolve the names against the system tables or use the object_namefunction within the context of the database. ... Over time we have replaced their applications with our own in-house applications, however not all of our programs have been upgraded so some of the tables and stored procedures may still be in use. ...
      (microsoft.public.sqlserver.tools)