Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 13 of 13 total
Thread TDBIsamTable CopyTable problem
Mon, Apr 8 2019 12:53 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< In my case it was a remote database and the 'access denied to table' exception was thrown because there was a lock on the table being held by the database server, >>

Did you have any dead sessions present on the DBISAM Database Server that might have the table open ?  You can view dead sessions (disconnected, but not removed yet), by using the Server Administration Utility.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Apr 8 2019 3:45 PMPermanent Link

John Taylor

Tim Young [Elevate Software] wrote:

John,

<< In my case it was a remote database and the 'access denied to table' exception was thrown because there was a lock on the table being held by the database server, >>

Did you have any dead sessions present on the DBISAM Database Server that might have the table open ?  You can view dead sessions (disconnected, but not removed yet), by using the Server Administration Utility.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Yes I did, there were no sessions listed at all in the admin utility.

I think I have it worked out here, I actually can session1.stopremoteserver then treat everything as local and it works fine.  Do you see any problem doing it that way?  I'm taking steps to ensure that the client software must be shutdown before the relocate can take place and as far as I can see all running threads are blocked in some manner (checking Evt or global boolean flag) so they won't access the database.


John
Fri, Apr 12 2019 11:54 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< I think I have it worked out here, I actually can session1.stopremoteserver then treat everything as local and it works fine.  Do you see any problem doing it that way? >>

No, you should be fine with that approach.

Tim Young
Elevate Software
www.elevatesoft.com
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image