Re: Delphi 5 + Win 2K

From: Swami (qswami_at_rediffmail.com)
Date: 08/24/04

  • Next message: Bryan Dayton: "TBetterADO is it better in D7?" 
    Date: Tue, 24 Aug 2004 11:00:35 +0530

    Thanks for the reply.

    > 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 ?

    It does not mean SQL server jobs... No SQL server jobs are scheduled.
    should ideally be 'deleting many records (containing that Blob data)...'

    The compress / uncompress components are removed from usage to eliminate any
    possible dependecies on them...
    Right now we have the data saved to a temporary ASCII file. From the Ascii
    file the data is loaded to the tree using tree routine
    Tree.Items.SaveToFile(StreamAsciiFile) and then put into the database using

    myQuery.Parameters.ParamByName('FieldName').LoadFromFile(StreamAsciiFile,
    ftBlob);

    Does this give any indication that the corruption is caused from the
    Component ?

    The MDAC version is 2.7 and MSSQL Service Pack 3

    Also, another point if it is of significance, the error occurs very
    frequently only on a laptop which also runs the
    SQL Server instance and not frequently on typical client machine trying it
    access data from a different Server machine.

    Thanks.

    "Del Murray" <Del.Murray@CreditHawk.Net.NoSpam> wrote in message
    news:412aa979$1@newsgroups.borland.com...
    > 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 ?
    >
    >

  • Next message: Bryan Dayton: "TBetterADO is it better in D7?"