Re: Delphi 5 + Win 2K

From: Del Murray (Del.Murray_at_CreditHawk.Net.NoSpam)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 22:40:28 -0400

What do you mean by the statement ...
" 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"
Do you mean SQL server jobs that are scheduled ? if so , do you have some
that are running constantly ?

What happens to the data if you take the compressed data in the component
and save it to a memory var (of proper type cuz I dont know what the
component native format is) and then uncompress it back into the tree , then
back into the var, back to the tree, etc... do this over and over until you
have done it some order of magnitue that represents the number of times you
can shove it into the database before it fails. This should tell you if the
corruption is caused by the componenet or the database ..

Try taking a good var with compressed data and do a sql "insert" n times in
a row and see if the data is good. I have never seen sql server corrupt
data,... I would be very suspicious of the compress routine not freeing
memory or expecting you to free memory for it.

Next thing is ... how do you put it into the database ....
mytable.fieldbyname('somebigchunk').value := ?? or do you treat it as a
tblob or what ?

Do you have the latest MDAC ?

What patch level of SQL Server ?