I've finally gotten around to looking at the anti-virus issues with respect
to temporary tables created by queries.  Does anyone have some installed
anti-virus software that is experiencing an 11010 or 11013 error code for
query temporary tables ?  And, if so, would you be willing to try a beta
version of 4.28 that attempts to fix this issue ?

The change for 4.28 revolves around creating such tables and keeping them
open, thus negating any possible way for the AV software to interject in the
process.  However, there is still the possibility that the AV software may
try some screwy quarantine or scan on the table files when they are closed,
but before they are deleted, so I want to see if there is still an issue
present.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<The change for 4.28 revolves around creating such tables and keeping them
open, thus negating any possible way for the AV software to interject in the
process.  However, there is still the possibility that the AV software may
try some screwy quarantine or scan on the table files when they are closed,
but before they are deleted, so I want to see if there is still an issue
present.>

Did you finally put this change on 4.28?

Tiago,

<< Did you finally put this change on 4.28?  >>

Yes, but it wasn't mentioned because it hasn't been confirmed yet that it
fixes the issue for good.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I tried the 4.28b1 and suddenly have tons of temp table files cluttering the
folder - not erased when app exits.

I do know they are created runtime but up to 4.27b5 they were deleted when
app exited.

There is no AV running.

Raul




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:F155076F-FEF2-4667-B1AA-0A6A4787A35C@news.elevatesoft.com...
> I've finally gotten around to looking at the anti-virus issues with
> respect to temporary tables created by queries.  Does anyone have some
> installed anti-virus software that is experiencing an 11010 or 11013 error
> code for query temporary tables ?  And, if so, would you be willing to try
> a beta version of 4.28 that attempts to fix this issue ?
>
> The change for 4.28 revolves around creating such tables and keeping them
> open, thus negating any possible way for the AV software to interject in
> the process.  However, there is still the possibility that the AV software
> may try some screwy quarantine or scan on the table files when they are
> closed, but before they are deleted, so I want to see if there is still an
> issue present.
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4120 (20090601) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4139 (20090608) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Raul,

<< I tried the 4.28b1 and suddenly have tons of temp table files cluttering
the folder - not erased when app exits. >>

Yes, see my post in the dbisam.sql newsgroup:

http://www.elevatesoft.com/newsgrp?action=openmsg&group=8&msg=13984&page=1#msg13984

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi

Can anyone confirm if that changes actually resolved 11013 problem for good?

I'm getting the 11010 error running the new Microsoft Security Essentials on Windows 7.  When "real time protection" is turned off, the exceptions go away.

Delphi 2010
DBISAM 4.29b2

Best regards,
Burton


"Tim Young [Elevate Software]" wrote:

I've finally gotten around to looking at the anti-virus issues with respect
to temporary tables created by queries.  Does anyone have some installed
anti-virus software that is experiencing an 11010 or 11013 error code for
query temporary tables ?  And, if so, would you be willing to try a beta
version of 4.28 that attempts to fix this issue ?

The change for 4.28 revolves around creating such tables and keeping them
open, thus negating any possible way for the AV software to interject in the
process.  However, there is still the possibility that the AV software may
try some screwy quarantine or scan on the table files when they are closed,
but before they are deleted, so I want to see if there is still an issue
present.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Burton,

<< I'm getting the 11010 error running the new Microsoft Security Essentials
on Windows 7.  When "real time protection" is turned off, the exceptions go
away. >>

Great.

On what table name are you getting the 11010 error ?  Is it a random
temporary table name, and does the error occur during query execution ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
It is a random temp table name (actually a number).

"Exception class EDBISAMEngineError with message 'DBISAM Engine Error #11010 Table or backup file '37889' does not exist'.

I've attached a screen shot of the call stack.

Burton


"Tim Young [Elevate Software]" wrote:

Burton,

<< I'm getting the 11010 error running the new Microsoft Security Essentials
on Windows 7.  When "real time protection" is turned off, the exceptions go
away. >>

Great.

On what table name are you getting the 11010 error ?  Is it a random
temporary table name, and does the error occur during query execution ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Burton,

<< It is a random temp table name (actually a number).

"Exception class EDBISAMEngineError with message 'DBISAM Engine Error #11010
Table or backup file '37889' does not exist'.

I've attached a screen shot of the call stack. >>

Thanks, I'll see what I can find out.  In the meantime, if there is a way to
configure exceptions for the real-time protection, then I would configure an
exception for any temporary files directories used in your DBISAM
application.  That way the MS security software won't keep trying to
delete/quarantine the files.

--
Tim Young
Elevate Software
www.elevatesoft.com