Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
A bit of a TService problem |
Wed, Oct 18 2006 9:41 PM | Permanent Link |
Mark Shapiro | Under the control of a middleware server, my application uses a TMemoryStream to copy its
DBISAM tables to a back-up folder in the early hours of the morning. The application logs the following error only on those sytems that are running the server application as a service: exception class : EFOpenError exception message : Cannot open file "F:\Apps\Alice\tables\Child.dat". The process cannot access the file because it is being used by another process. I'm closing and then re-opening the TDBISAMDatabase component prior to the back-up. This works fine in non-service setups Is there a way to release any table locks within a service application or otherwise get around this problem? Mark Shapiro |
Thu, Oct 19 2006 5:11 AM | Permanent Link |
Telling the session to close is how I've done this - it makes sure any
temporary things are closed too. /Matthew Jones/ | |
Thu, Oct 19 2006 1:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mark,
<< I'm closing and then re-opening the TDBISAMDatabase component prior to the back-up. This works fine in non-service setups Is there a way to release any table locks within a service application or otherwise get around this problem? >> This isn't specific to services per se. I would verify that there isn't any session/data module caching in the middleware server. If there is, then make sure that you call the appropriate methods to clear out the cache prior to running the backup. That will make sure that all open tables are closed so that you can access them as necessary. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 20 2006 1:23 PM | Permanent Link |
Mark Shapiro | Mathew & Tim,
I'm not aware of any data caching going on but I will try turning the session off and on. I had wanted to avoid that simply to avoid reloading password settings. However, that's a minor consideration. Thanks to you both. Mark Shapiro |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |