Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread DBISAM ENGINE ERROR 11013 Access denied to table or Backup file "85920"....
Wed, Apr 25 2018 8:49 AMPermanent Link

Mesotech

Mesotech

Hello I've got this error with al my table when I use ORDER BY in my SQL on a table located on a server :
(in local mode : no error)

Exemple :
SELECT * FROM PAYS WHERE ACTUAL = '1'
Execution without error...

SELECT * FROM PAYS WHERE ACTUAL = '1' ORDER BY LIBCOG;execution
produce the error

I'm using DBISAM Version 4.44 Build 3 with Delphi7...

Programme is running on WIN10 And the database is on an other WIN10 computer...

How to solve this ?
Thank You in advance for any help.
Wed, Apr 25 2018 11:09 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mesotech


My guess would be that its a folder permissions problem. I'd further guess that the first query produces a live (sensitive) result set and the second a canned (insensitive) one.

Three things you can do

1: add an index for LIBCOG. This will mean you get a live result set so the permissions problem shouldn't occur

2: alter the directory where temporary files are stored (I think that would be the PrivateDir property but its a while since I used DBISAM)

3: alter the permissions for the folder where the temporary files are currently being created (probably the Windows temp folder)

Roy Lambert
Wed, Apr 25 2018 11:51 AMPermanent Link

Mesotech

Mesotech

Hello Roy,

Thank you for your help.

I've created the index : Nothing change same error message...
I've modified the permission for the widnows/temp folder : nthing change, same error message...
Like the the database is on a server, I've read the private dir is not used (used only for local database)... I've placed empty string for it : Nothing change : same error...

Still looking for a solution...

With best regards,
Mesotech
Wed, Apr 25 2018 12:29 PMPermanent Link

Mesotech

Mesotech

Hello,

How to know the folder, or force it to use a tempdir if we are in remote (client server) situation ?

For a local session the privatetempdir works fine ...

Still looking for a solution for my error...

With best regards,
Mesotech
Wed, Apr 25 2018 12:41 PMPermanent Link

Mesotech

Mesotech

Hello
it seems that's if i run the server in Administrator mode : all is ok...

So now the solution should be to force the server to write temp files in a directory that doesn't need administrator rights...

So where to force this directory in code, please ?

Still looking for a solution for my error...

With best regards,
Mesotech
Wed, Apr 25 2018 2:25 PMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 4/25/2018 12:41 PM, Mesotech wrote:
> it seems that's if i run the server in Administrator mode : all is ok...
>
> So now the solution should be to force the server to write temp files in a directory that doesn't need administrator rights...

What folder are you running dbsrvr from ?

Can you just add permissions to allow file read/write in that folder -
that should solve it.

Raul



Wed, Apr 25 2018 3:13 PMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 4/25/2018 2:25 PM, Raul wrote:
> On 4/25/2018 12:41 PM, Mesotech wrote:
>> it seems that's if i run the server in Administrator mode : all is ok...
>>
>> So now the solution should be to force the server to write temp files
>> in a directory that doesn't need administrator rights...
>

Never mind my previous answer

There is a config setting for this - use server admin utility to log
into your dbsrvr instance and on "Server" tab you can specify "temp
files directory" path

Raul
Wed, Apr 25 2018 4:26 PMPermanent Link

Mesotech

Mesotech

Hello Raul,

Big thank you for your very good help !

I've change the directory with the srvadmin.exe tool...

And now it seems to work...

With best regards,
Mesotech
Image