Re: problem with esql
Posted in 1998
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues
Thank you for the advice, my installation was indeed flawed, (this is the
first time
I install an Informix product). I had installed SE and ESQLC in two
different
subdirectories, and pointed $INFORMIXDIR to the subdirectory where SE is.
I realized my mistake, reinstalled the product (SE and ESQLC) into the same
INFORMIXDIR, and now both dbaccess and esql run well.
Thanks
Chris
Jonathan Leffler wrote:
> Chris wrote:
> > I installed informix SE on Linux (slackware, linux 2.0.30), and
> > installed the demo database. dbaccess runs well, but I was unable to
> > user the preprocessor for any of the *.ec programs. For example, the
> > first example in the ESQL/C manual says to use the following command:
> > esql -o demo1 demo1.ec. It gave the following error: unknown error
> > message 33000. I tried other parameters with esql, such as -e, -ansi,
> > etc, but they all give the same error.
>
> That's an unusual number, but I'd concur with Keith Moffat that the
> chances are that you've not got your complete Informix environment.
> What's odd is that DB-Access works. Did you install SE and ESQL/C
> in the same INFORMIXDIR? If not, then that's the trouble. If so,
> did you change the environment between running DB-Access and ESQL/C?
>
> I wonder if it could be LD_LIBRARY_PATH? On RedHat 5.1, the wonderful
> X system quietly clobbers LD_LIBRARY_PATH -- unsets it completely.
> That is a pain in the posterior if you do as I do, which is to login
> under a terminal and then run X. Still, the ESQL/C doesn't normally
> depend on that -- it is just the programs you build which do.
>
> At any rate, check your environment very carefully.
>
> --
> Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
> Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
> #include <disclaimer.h>