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/
