![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Wed, Apr 25 2018 8:49 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 AM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Raul ![]() | 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 PM | Permanent Link |
Raul ![]() | 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 PM | Permanent 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 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |