Strange stuff from firebird I am hoping to get some insight on...please bear with me while I describe the problem!

I've run into a problem with a firebird installation that is using a 3rd party report viewer to display crystal reports from a firebird db on client PCs...this is a windows environment.

the text of the error quoted here is from the sql trace log:

"DIAG [HY000] [ODBC Firebird Driver][Firebird]I/O error for file "C:\WINDOWS\TEMP\fb_sort_###### Error while trying to open file
The data is invalid. (-902)"

And it seems to relate to this error message in the FB docs:

-902 335544344 io_error I/O error for file "@2"

The best explanation I have found in the bing/google-verse is from another post on this group:

"Firebird creates sort files in the assigned temp directory if you
don't have enough space in memory for them. Code 335544344 is an i/o
error, either you are out of space on your C drive or Firebird can't
access your temp directory for some reason."

In due diligence the drive that c:\windows\temp is on has ~50GB free; EVERYONE has been given all privileges to the folder; And I can't fathom why Firebird wouldn't be able to access the folder for any reason.

The server is operating on another machine under default conf...meaning everything in the file was commented.

As a test I enabled 4x settings on each in-memory or related parameter in the conf, bounced the server and tested the report again with the same results.

The odbc driver is 2.0.0.144 and the server is running firebird 1.5.

The kicker: there is only one report (the most important one, desired by the users, of course) that is affected by this problem.

Any advice, insights, or helpful comments of any kind would be appreciated.

Thanks RT