ESQL cannot be found After CSDK Install

Posted in 2010

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues

BRIAN JACOBS — Wed, 07 Jul 2010 22:07:24 — source: IIUG Forums & Mailing Lists

Hello All, here are my products I am using on a HP-UX 11.23 system: Informix SQL Development V7.50.HC1 HP-UX 11.x 32 bit English(C1EU8EN), Informix Dynamic Server Enterprise Edition V11.50.FC6 HP-UX 11 PARISC 64 bit English(CZ6QDEN), and Informix Client SDK V3.50.Hc1 HP-UX 11 PA-RISC 32 Bit English(C1B8CEN). This list of software came from reading an ealier post here in reference to an iSQL error (1005) that I was receiving. I re-installed my IDS Instance in the order I was given (SQL Dev, IDS and CSDK). The advice was to install the C6 version of the CSDK in either a separate directory or use a version C5 or less hence the C1 version. I also installed that into its own directory - CSDK32 under the $INFORMIXDIR. The 1005 error is gone but now it cannot find eSQL: "/apps/informix/development/tacsdev/CSDK32/bin/esql851]: /apps/informix/development/tacsdev/lib/esql/esqlc: not found." I am sure it is a environment thing but I am a bit new at this. Can someone please help? Thank you in advance. Here are the ENV Variables: informix:/tmp $ env _=/usr/bin/env MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u sr/local/man/%L:/usr/local/man:/opt/graphics/common/ man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/ipf/man:/usr/dt/share/ma n:/opt/samba/man:/opt/resmon/share/man/%L:/opt/resmo n/share/man:/opt/sec_mgmt/share/man:/opt/gnome/man:/opt/openssl/man:/opt/openssl /prngd/man:/opt/wbem/share/man:/opt/perl/man:/opt/se c_mgmt/share/man/%L:/opt/ssh/share/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/VRTS/ man:/opt/omni/lib/man:/opt/hpnpl//man:/opt/perf/man/ %L:/opt/perf/man:/opt/audio/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/m an:/opt/langtools/share/man/%L:/opt/langtools/share/ man:/opt/image/share/man:/opt/imake/man:/opt/cifsclient/share/man:/opt/iexpress/ gnupg/man SHLIB_PATH=:/apps/odcs/bin:/apps/odcs/bin DBLANG=/apps/informix/development/tacsdev/msg/en_us/0333 PATH=/apps/informix/development/tacsdev/bin:/apps/informix/development/tacsdev/bin:/usr/local/bin:/etc:/reflection:/usr/bin:/opt/ans ic/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hpar ray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/local/b in:/usr/contrib/kwdb/bin:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrade/bin: /opt/ipf/bin:/opt/resmon/bin:/opt/ignite/bin:/opt/se c_mgmt/bastille/bin:/opt/gnome/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sec_mgmt/sp c/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/usr/sbin/diag/co ntrib:/opt/omni/bin:/opt/hpnpl/bin:/opt/perf/bin:/opt/VRTS/bin:/opt/langtools/bi n:/opt/imake/bin:/opt/lib/cobol:/opt/lib/cobol/lib:/ usr/lib:/usr/contrib/bin/X11:/opt/firefox:/opt/mozilla:/opt/omni/sbin:/opt/omni/ lbin:/opt/hpsmh/lib:/opt/samba:/usr/local/lib::/usr/ local/bin/:/usr/local/bin/ COLUMNS=132 INFORMIXSQLHOSTS=/apps/informix/development/tacsdev/etc/sqlhostsEDITOR=vi LOGNAME=informix DBCENTURY=C MAIL=/var/mail/informix ERASE=^H PS1=$LOGNAME:$PWD $ TERMCAP=/apps/informix/development/tacsdev/etc/termcap XPORT_USER=bsi SHELL=/usr/bin/sh HOME=/home/informix INFORMIXDIR=/apps/informix/development/tacsdev LD_LIBRARY_PATH=:/apps/informix/development/tacsdev/lib:/apps/informix/development/tacsdev/lib/esql TERM=vt100 DBEDIT=vi ONCONFIG=onconfig.tacsdevPWD=/tmp TZ=YST9YDT origpath=/usr/local/bin:/etc:/reflection:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/u sr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/op t/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/local/bin:/usr/contrib/kwdb/b in:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrad e/bin:/opt/ipf/bin:/opt/resmon/bin:/opt/ignite/bin:/opt/sec_mgmt/bastille/bin:/o pt/gnome/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sec_m gmt/spc/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/usr/sbin/diag/contrib:/opt/omni/bin:/o pt/hpnpl/bin:/opt/perf/bin:/opt/VRTS/bin:/opt/langto ols/bin:/opt/imake/bin:/opt/lib/cobol:/opt/lib/cobol/lib:/usr/lib:/usr/contrib/b in/X11:/opt/firefox:/opt/mozilla:/opt/omni/sbin:/opt /omni/lbin:/opt/hpsmh/lib:/opt/samba:/usr/local/lib::/usr/local/bin/:/usr/local/ bin/ LINES=26 INFORMIXSERVER=tacsdev esql file locations: /apps/informix/development/tacsdev/msg/en_us/0333/esqlc.iem /apps/informix/development/tacsdev/CSDK/UNIX/doc/esqlc_relnotes_3.50.html /apps/informix/development/tacsdev/CSDK/UNIX/doc/esqlc_relnotes_3.50.txt /apps/informix/development/tacsdev/ICONNECT/UNIX/doc/esqlc_relnotes_3.50.html /apps/informix/development/tacsdev/ICONNECT/UNIX/doc/esqlc_relnotes_3.50.txt /apps/informix/development/tacsdev/doc/esqlc_relnotes_3.50.html /apps/informix/development/tacsdev/doc/esqlc_relnotes_3.50.txt /apps/informix/development/tacsdev/CSDK32/lib/esql/esqlc /apps/informix/development/tacsdev/CSDK32/lib/esql/esqlcdb2 /apps/informix/development/tacsdev/CSDK32/demo/esqlc

↪ replying to BRIAN JACOBS

Art Kagel — Wed, 07 Jul 2010 22:34:34 — source: IIUG Forums & Mailing Lists

In order to compile successfully, you will have to set INFORMIXDIR to /apps/informix/development/tacsdev/CSDK32 or edit the esql script in /apps/informix/development/tacsdev/CSDK32/bin to reference esqlc explicitely in /apps/informix/development/tacsdev/CSDK32/lib/esql rather than in $INFORMIXDIR/lib/esql. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jul 7, 2010 at 6:07 PM, BRIAN JACOBS <bjacobs@co.fairbanks.ak.us>wrote: > Hello All, here are my products I am using on a HP-UX 11.23 system: > Informix SQL Development V7.50.HC1 HP-UX 11.x 32 bit English(C1EU8EN), > Informix Dynamic Server Enterprise Edition V11.50.FC6 HP-UX 11 PARISC 64 > bit > English(CZ6QDEN), and Informix Client SDK V3.50.Hc1 HP-UX 11 PA-RISC 32 Bit > English(C1B8CEN). This list of software came from reading an ealier post > here > in reference to an iSQL error (1005) that I was receiving. I re-installed > my > IDS Instance in the order I was given (SQL Dev, IDS and CSDK). The advice > was > to install the C6 version of the CSDK in either a separate directory or use > a > version C5 or less hence the C1 version. I also installed that into its own > directory - CSDK32 under the $INFORMIXDIR. The 1005 error is gone but now > it > cannot find eSQL: "/apps/informix/development/tacsdev/CSDK32/bin/esql851]: > /apps/informix/development/tacsdev/lib/esql/esqlc: not found." I am sure it > is > a environment thing but I am a bit new at this. Can someone please help? > Thank > you in advance. > > Here are the ENV Variables: > informix:/tmp $ env > _=/usr/bin/env > > > MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u sr/local/man/%L:/usr/local/man:/opt/graphics/common/ > > > man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/ipf/man:/usr/dt/share/ma n:/opt/samba/man:/opt/resmon/share/man/%L:/opt/resmo > > > n/share/man:/opt/sec_mgmt/share/man:/opt/gnome/man:/opt/openssl/man:/opt/openssl /prngd/man:/opt/wbem/share/man:/opt/perl/man:/opt/se > > > c_mgmt/share/man/%L:/opt/ssh/share/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/VRTS/ man:/opt/omni/lib/man:/opt/hpnpl//man:/opt/perf/man/ > > > %L:/opt/perf/man:/opt/audio/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/m an:/opt/langtools/share/man/%L:/opt/langtools/share/ > > > man:/opt/image/share/man:/opt/imake/man:/opt/cifsclient/share/man:/opt/iexpress/ gnupg/man > SHLIB_PATH=:/apps/odcs/bin:/apps/odcs/bin > DBLANG=/apps/informix/development/tacsdev/msg/en_us/0333 > > > PATH=/apps/informix/development/tacsdev/bin:/apps/informix/development/tacsdev/bin:/usr/local/bin:/etc:/reflection:/usr/bin:/opt/ans > > > ic/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hpar ray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/local/b > > > in:/usr/contrib/kwdb/bin:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrade/bin: /opt/ipf/bin:/opt/resmon/bin:/opt/ignite/bin:/opt/se > > > c_mgmt/bastille/bin:/opt/gnome/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sec_mgmt/sp c/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/usr/sbin/diag/co > > > ntrib:/opt/omni/bin:/opt/hpnpl/bin:/opt/perf/bin:/opt/VRTS/bin:/opt/langtools/bi n:/opt/imake/bin:/opt/lib/cobol:/opt/lib/cobol/lib:/ > > > usr/lib:/usr/contrib/bin/X11:/opt/firefox:/opt/mozilla:/opt/omni/sbin:/opt/omni/ lbin:/opt/hpsmh/lib:/opt/samba:/usr/local/lib::/usr/ > local/bin/:/usr/local/bin/ > COLUMNS=132 > INFORMIXSQLHOSTS=/apps/informix/development/tacsdev/etc/sqlhosts> EDITOR=vi > LOGNAME=informix > DBCENTURY=C > MAIL=/var/mail/informix > ERASE=^H > PS1=$LOGNAME:$PWD $ > TERMCAP=/apps/informix/development/tacsdev/etc/termcap > XPORT_USER=bsi > SHELL=/usr/bin/sh > HOME=/home/informix > INFORMIXDIR=/apps/informix/development/tacsdev> > > LD_LIBRARY_PATH=:/apps/informix/development/tacsdev/lib:/apps/informix/development/tacsdev/lib/esql > TERM=vt100 > DBEDIT=vi > ONCONFIG=onconfig.tacsdev> PWD=/tmp > TZ=YST9YDT > > > origpath=/usr/local/bin:/etc:/reflection:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/u sr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/op > > > t/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/local/bin:/usr/contrib/kwdb/b in:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrad > > > e/bin:/opt/ipf/bin:/opt/resmon/bin:/opt/ignite/bin:/opt/sec_mgmt/bastille/bin:/o pt/gnome/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sec_m > > > gmt/spc/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/usr/sbin/diag/contrib:/opt/omni/bin:/o pt/hpnpl/bin:/opt/perf/bin:/opt/VRTS/bin:/opt/langto > > > ols/bin:/opt/imake/bin:/opt/lib/cobol:/opt/lib/cobol/lib:/usr/lib:/usr/contrib/b in/X11:/opt/firefox:/opt/mozilla:/opt/omni/sbin:/opt > > > /omni/lbin:/opt/hpsmh/lib:/opt/samba:/usr/local/lib::/usr/local/bin/:/usr/local/ bin/ > LINES=26 > INFORMIXSERVER=tacsdev> > esql file locations: > /apps/informix/development/tacsdev/msg/en_us/0333/esqlc.iem > /apps/informix/development/tacsdev/CSDK/UNIX/doc/esqlc_relnotes_3.50.html > /apps/informix/development/tacsdev/CSDK/UNIX/doc/esqlc_relnotes_3.50.txt > > /apps/informix/development/tacsdev/ICONNECT/UNIX/doc/esqlc_relnotes_3.50.html > > /apps/informix/development/tacsdev/ICONNECT/UNIX/doc/esqlc_relnotes_3.50.txt > /apps/informix/development/tacsdev/doc/esqlc_relnotes_3.50.html > /apps/informix/development/tacsdev/doc/esqlc_relnotes_3.50.txt > /apps/informix/development/tacsdev/CSDK32/lib/esql/esqlc > /apps/informix/development/tacsdev/CSDK32/lib/esql/esqlcdb2 > /apps/informix/development/tacsdev/CSDK32/demo/esqlc > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636b2b0f3eebd2b048ad3c5bb

↪ replying to Art Kagel

BRIAN JACOBS — Thu, 08 Jul 2010 22:51:16 — source: IIUG Forums & Mailing Lists

Thank you Art, the solution was perfect. Objects are now compiling.

ESQL cannot be found After CSDK Install

Glossary

Your privacy choices