You were right on...it was a user perm issue on the server.

Thanks for your help!

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