Hi Thomas,

Thank you very much for your help.

I had forgotten to create temporary directory :( and give appropiate privileges to firebird user.

The solution worked great.

Hernando.

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > 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
>