Subject Re: Error when trying to "SELECT" "ORDERED BY" not indexed column ?
Author Plamen Krastev
> > ISC ERROR MESSAGE:
> > I/O error for file "C:\WINDOWS\system32
\WINDOWS\TEMP\fb_sort_x2l31t"
>
> That is a strange Temp folder location. Have you set this in
> Firebird.conf?

You are right Adam, that directory does not exist on my C: drive. May
be my problem is connected with the fact that I had to change the Temp
directory location because some of the software installed on my
computer cannot work with the very long default path to temporary
directory in Windows XP.

Temporary directory is not set by default in Firebird.conf, and by
some reason it cannot find the right temporary directory location in
my case. But setting it explicitly in Firebird.conf with the line:

TempDirectories = c:\Temp

resolved the problem ( c:\Temp exists of course ).

Thank you for the help.