Re: LOCFILE -454 problem

Ray O'Hagan wrote: > > Hi, > > I've developed an application which run as an NT server on NT Server 4.0 > > running Informix 7.30. I have a problem when I try to insert a text blob > > from a file using the LOCFILE mechanism. It constantly returns a -454 > error (loc_read() failed). I know the file is valid and open as I've > been doing fread() calls previous > to trying to insert the text blob. Does anyone know of anything specific > I might have > to do to get LOCFILE working under an NT service, or is there anything > else I might > be doing wrong ? (note this code was originally ported from UNIX where > it works perfectly). I do not know why your program is having this problem. However, let me suggest as a workaround using LOCUSER. The method is not as hard as it looks and it is MUCH faster than either LOCFILE or LOCMEMORY you just provide your own functions to open, and close the BLOB file and read N bytes file into the SQL buffer. Art S. Kagel