> Linux CentOS 5.8 box with Firebird 2.1 clasic:
>
> When I run a "SELECT * FROM my_table", this returns records ok, but if I execute "SELECT * FROM my_table ORDER BY my_date_field" returns the following error:
>
> Statement failed, SQLCODE = -902
> operating system directive open failed
> -No such file or directory
>
> I can't find how to fix this.
>
> Any help will be appreciated.

Ordering by my_date_field results in writing intermediate data onto disk
into a temporary directory. Make sure that Firebird is able to access
the temporary directory from a security POV and that there is enough
disk space for the temp directory available.


Regards,
Thomas