You were right on...it was a user perm issue on the server. Thanks for your help!
--- In [email protected], 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/ >
