Hello,

> 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.

What does: "The sever is operating on another machine ..."?

The above mentioned directory must be local to the Firebird server and
not to the client. Just in case ...



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/