Hello

I have a problem regarding 11013 error message.
I was opening tables on one of my directories (not on local machine) and at some moment got an error 11013. I didn't think that would be a problem as all I had to do was close the process of my application which was left hanging after crash.
It didn't help. In fact ... now I could not open even those .dat files that I could open few minutes before. I get 11013 message every time. All of that was happening on my (local) machine. I tried that on one other local machine and got the same result.
Then I tried that on the server (physical machine) and I could open all my tables in that directory.
I tried with reset of my local and server computers and that didn't do any good as well.
So now I don't know who or what is holding those files locked? Is it DBISAM server or system? How to see that? How to prevent that kind of locking? I really get that message a LOT with my application. So I would like to know what to change in my application or anywhere else.
Any tips on how to code your program in order to avoid such problems? What do I have to add to my code to make it more stable (regarding this error message)?

thank you

Sašo

1


Reading the manual for that error code gives:

DBISAM_OSEACCES (11013)
Access denied to table or backup file '<Name>'
This error usually occurs when an attempt is made to open up
a table or backup file and the operating system does not allow
access to the table or backup file due to the fact that it has
already been opened up exclusively by another application or
the same application or a user rights issue. A table can be
opened exclusively only once. It can also occur when an
attempt is made to open up a table for read/write access that
is in a read-only directory or on a read-only drive and not
marked as read-only as an attribute. Please see the Opening
Tables topic for more information. It is also possible that a
table's backup files cannot be overwritten during the
processing of altering the structure of a table, adding indexes
to a table or deleting indexes from a table, or optimizing a
table. Please see the Creating and Altering Tables, Adding and
Deleting Indexes from

So since you say you get it a lot in your app probably means you have problems with file rights.


Roy Lambert [Team Elevate]

Roy Lambert wrote:

1


Reading the manual for that error code gives:

DBISAM_OSEACCES (11013)
Access denied to table or backup file '<Name>'
This error usually occurs when an attempt is made to open up
a table or backup file and the operating system does not allow
access to the table or backup file due to the fact that it has
already been opened up exclusively by another application or
the same application or a user rights issue. A table can be
opened exclusively only once. It can also occur when an
attempt is made to open up a table for read/write access that
is in a read-only directory or on a read-only drive and not
marked as read-only as an attribute. Please see the Opening
Tables topic for more information. It is also possible that a
table's backup files cannot be overwritten during the
processing of altering the structure of a table, adding indexes
to a table or deleting indexes from a table, or optimizing a
table. Please see the Creating and Altering Tables, Adding and
Deleting Indexes from

So since you say you get it a lot in your app probably means you have problems with file rights.


Roy Lambert [Team Elevate]

Thank you but...

I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives.
Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies.

Sašo

Sašo

>Thank you but...
>
>I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives.
>Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies.

SysInternals (somewhere on the MS site) should have a tool that can do that, or one of the unlockers (just search for unlocker on the internet) should be able to tell you who has a file locked.

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Sašo

>Thank you but...
>
>I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives.
>Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies.

SysInternals (somewhere on the MS site) should have a tool that can do that, or one of the unlockers (just search for unlocker on the internet) should be able to tell you who has a file locked.

Roy Lambert [Team Elevate]

Thank you for your support. I will definitely have to try it.

Sašo

Sašo


Are you using client/server or file/server.

Do you have any backup processes running? Could it be av software?

Could it be a network hardware issue?

Roy Lambert [Team Elevate]

ps you posted this in the ElevateDB ng not the DBISAM one

Roy Lambert wrote:

Sašo


Are you using client/server or file/server.

Do you have any backup processes running? Could it be av software?

Could it be a network hardware issue?

Roy Lambert [Team Elevate]

ps you posted this in the ElevateDB ng not the DBISAM one


Oops. I apologize for posting in the wrong section.

I am using client/server and for the rest of your questions I have to say that I don't know precisely. But I will have to look into that.

thank you

Sašo

Sašo


>Oops. I apologize for posting in the wrong section.

No problem.

>I am using client/server and for the rest of your questions I have to say that I don't know precisely. But I will have to look into that.

If its c/s then all the file handling should be being done by the server so I'm slightly more baffled.

Another thought - go on to ElevateSofts website and shove 11013 into the search and see what, if any, light that can throw on the subject.

Roy Lambert [Team Elevate]

Iztok,

<< I have a problem regarding 11013 error message.  >>

11013 "access denied" errors are caused by incompatible file open modes at
the OS level, and not specifically DBISAM locking.  For example, if another
process opens one the .dat files exclusively, like in the case of an
anti-virus engine performing real-time scanning, then this would prevent
DBISAM from opening the .dat file in shared mode and you would see such an
error.

You can see what files are open by starting the Computer Manager on the
machine that is hosting the files (Windows 7 example):

Control Panel/Administrative Tools/Computer Management/Shared Folders/Open
Files

Windows Server 2003/2008 has a similar management console.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

thank you for the information. I didn't know for this option.

Regards
Iztok Lajovic

"Tim Young [Elevate Software]"  je napisal v sporoÄ�ilo
news:E227F8EF-87F5-4983-BB5C-15E02A14AE6B@news.elevatesoft.com ...

Iztok,

<< I have a problem regarding 11013 error message.  >>

11013 "access denied" errors are caused by incompatible file open modes at
the OS level, and not specifically DBISAM locking.  For example, if another
process opens one the .dat files exclusively, like in the case of an
anti-virus engine performing real-time scanning, then this would prevent
DBISAM from opening the .dat file in shared mode and you would see such an
error.

You can see what files are open by starting the Computer Manager on the
machine that is hosting the files (Windows 7 example):

Control Panel/Administrative Tools/Computer Management/Shared Folders/Open
Files

Windows Server 2003/2008 has a similar management console.

--
Tim Young
Elevate Software
www.elevatesoft.com