Re: Help Needed! - 461 Error Encountered

I was sorely tempted not to reply -- I can't tell from the 'Reply-To:' entry who I'm talking to, and I don't like enigmatic correspondents! Since I'd already typed the response before I noticed this, I decided to reply anyway, but I don't like not knowing who I'm talking to! Ugh! On Tue, 14 Oct 1997, Enigma wrote: > I've encountered a -461 when I tried to open a database in an esql/c > application program. Which version of ESQL/C? Probably a 5.0x, but not certain... This normally occurs because the installation is incorrect; the missing file is often $INFORMIXDIR/msg/itoxmsg.pam, or the file may be incorrect. Anyway, check the installation order: TEN -- tools, engines, network. > Finderr -461 returns the following: > > "File open error. > This statement transfers a value between a file and a BYTE or TEXT > column. Since the locator structure field loc_loctype was set to > LOCFNAME, the database server tried to open the file using the pathname > in loc_fname and the flags in loc_oflags. An operating-system error was > returned. Check the accompanying ISAM error code for more information, > and look for operating-system messages. Typical causes include lack of > disk space, file permission problems, and limits on the number of open > files." The message is referring to blobs, but is misleading. For some reason, it was decided to expand the scope of the message so that it not only applies to blob handling errors but also to some other errors. > What kind of file is this referring? I've checked my filesystem > and there's no lack of disk space. As I do not know what kind of file > it's referring to, I can't check for file permission. Is there any way > I can check for no of open files?? It's unlikely to be any of that lot of problems. Either a file is missing completely, or a file has the wrong information in it (because, for example, you installed the 4.1x I4GL software after installing the 5.0x ESQL/C and OnLine). Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>