x2412421 wrote:

> In fact, this is one of my customers that is having this problem. So,
> I'm not on site to test it by myself.
>
> So, since this problem occurs only on the client side and not on the
> server side, I thought that it could be a problem with available
> space on the client workstation.
>
> Now, since you told me that this is a problem that is returned by the
> server itself, and since this problem occurs only on the client side
> (and not on the server side) do you have any idea of what the problem
> could be?
>
> Thanks.
>

In fact it happens on the SERVER side, but the server returns the
exception to the client, because the "problem" was originated by a
client request, the SQL statement sent by the client produces a sort
file on the server, the problem lies on creating that sort file. The
reasons could be:

Out of disk space on the server
Lack of permissions by the engine (the account which the engine runs) to
create a file on that directory

How much space left you have on the c: drive ?
The account used by the engine has permissions to create the file on
that directory ?
Did you tried to change the temp file location on firebird.conf ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br