RE: ESQL: Unknown error message -33071.

It is true that when you have such 'unknown error', there is usually = something wrong with your env variables. However, when I had the = 'unknown error' for 'dbaccess', there were nothing wrong with = $INFORMIXDIR, $PATH, etc (I DID have checked all of them before I mailed = my post). =20 I found out later that the problem was caused by $SQLEXEC. It had been = set to 'sqlrm' for Relay Module, when I 'unset SQLEXEC', everything = turned to be OK. =20 I am not sure that your case is the same as my one, but this may give = you some hints. ---------- From: Felix Koshy Mathews[SMTP:fmathews@systems.dhl.com] This is the same kind of problem as the following one, so read the following, it will provide you the answer. In that case they were having problem with dbaccess, you are having problem in accessing the compile scripts. -------------------------------------------------------------------------= ------------------------------------ In <01BC3867.BE5BB780@swong.den.csci.csc.com>, Sean Wong wrote: > >o/s : "hp-ux 10.01 C"; OnLine 5.08.UC1; isql: 4.14.UC1; = dbaccess:5.08.UC1 > >When I attached to an OnLine instance under my own login, I have no >problem of running 'isql' and 'dbaccess'. However, if I login as user >'informix', when I try to run 'dbaccess', the engine returned me >following error: > 23101: Unknown error message -23101> >But there is no problem with 'isql'. Has someone come across this >before? The order in the '.snfile' is : SQL, 4GL, ESQL/C, OnLine. Sean, Do you have more than one version of Informix installed in your machine. In which case when you run "dbaccess" it could probably be executiong dbaccess from the other directory ( because of your $PATH ). When you execute dbaccess or similar tools if the related files like messages etc are not under that INFORMIXDIR, it will give you ?????: Unknown error message -????? Basically you need to have the engine,tools,messages,etc. under the same directory(INFORMIXDIR), if it is not, then you need to reinstall. In case of 2-versions of Informix say V7.0 & V7.2 if your INFORMIXDIR is pointing to V7.0, but your $PATH points V7.2 before V7.0 ( PATH=3D...:V7.2:...:V7.0... ) then by typing "dbaccess" you are =executing V7.2's "dbaccess". Now messages and related files under $INFORMIXDIR is of V7.0. This will give you an "?????: Unknown error message -?????" Check which dbaccess will be executed, by "type dbaccess". Good Luck Felix K. Mathews