Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Access violation while Optimising (DBISAM)
Wed, May 7 2008 2:52 AMPermanent Link

Sachith Gunawardane
Hi,

We have written Windows service to optimise our DBISAM database. We use OptimizeTable('',TRUE) function to optimise. Because its runs as
service, it create all the temporary files under Windows, System32 folder. My virus scanner blocks these files so, some times Im getting
access violation.

Is there any way to set temporary folder in OptimiseTable function?

Thank you,
Regards,
Sachith
Wed, May 7 2008 6:35 AMPermanent Link

"Jose Eduardo Helminsky"
Sachith

Just before you open any table or query just set

Session.PrivateDir := ExtractFilePath(ParamStr(0));

In this way you drive DBISAM to create temporary tables in the same folder
that your service is located, but you have to be sure that the app has all
rights to this folder.

Eduardo

Wed, May 7 2008 7:54 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Sachith


Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;


Roy Lambert [Team Elevate]
Tue, Jun 24 2008 7:18 AMPermanent Link

Sachith Gunawardane
Hi Roy


<<Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;>>

We are using DBISAM version 3.24

Regards,
Sachith
Image