I have installed the version 9.2 of ESQLC, and when I try to run the program in the following manner:
esql -e crdb.ec
cc -c -I/home/informix/incl/esql crdb.c
cc -ocrdb7.exe crdb.o home/informix/lib/esql/libgen.a
We get the following error:
NCR High Performance C Compiler R3.0c(c) Copyright 1994-97, NCR Corporation(c) Copyright 1987-97, MetaWare IncorporatedUndefined first referenced symbol in fileifx_coll_update_pos /home/informix/lib/esql/libsql.a(iqcollct.o)_chk_qual /home/informix/lib/esql/libsql.a(iqsend.o)ifx_coll_next /home/informix/lib/esql/libsql.a(iqcollct.o)
We get this error whenever we use any stmt like the following:
EXEC SQL CONNECT TO :dbase;
The same program worked perfectly fine with my previous version of ESQL/C. Please suggest how to fix. Has this got something to do with including a different library?
Yes, it looks like some sort of a library problem. I’ve had the same problems with the later versions of ESQL/C and actually had to de-install the new version and re-install a 7.23 version to get it to work. Check your INCLUDE, PATH, and LIB environment settings and be sure that you’re hitting all the right spots. If that doesn’t work, call Informix Tech Support and see if they have seen this problem before.