On Thu, 16 Aug 2001, Curt Russell Crandall wrote:
>Thanks for the information. I'm not authorized to rebuild
>DBD::Informix on these systems nor do I know when or how DBD::Informix
>was built last time. I'll forward your advice to the senior developer
>here.
That will be problematic. You've got to fix the problem without being
in control of the environment -- I'd be rather unhappy about this!
Either someone wants this fixed and will give you the authority to fix
it, or they don't want it fixed. It's make your mind up time! There's
enough complexity in a web server enabled with FastCGI to make it very
difficult to debug.
Since you can, presumably, modify the Perl script, you could print out
the environment before and after the DBI->connect() statement. However,
I'm not convinced it will give the same answer as the diagnostic code in
DBD::Informix -- that was there because Perl does not recognize when 3rd
Party code (eg Informix ESQL/C) changes the environment behind its back.
See also Perl 6 RFC-318 where I describe this peculiarity in some
detail.
>It's still a little confusing as to how I'll get the correct errstr the
>first time, but not after that. If /usr/informix is not the right
>value for $INFORMIXDIR, I would've thought that I would never get the
>error message in errstr.
Yes; I'm not completely clear about that. However, there is stuff in
some of the later versions of DBD::Informix which records the value of
INFORMIXDIR when the product is built and if the environment is not set
when it is loaded, the code sets INFORMIXDIR and INFORMIXSERVER to the
values prevailing during the build. This could be screwing things up
somehow. For example, if the value was set correctly by DBD::Informix
and then reset by the assignment in the code, this could cause trouble.
However, I'm far from convinced this is the case -- DBD::Informix is not
loaded until DBI->connect() is called, and you've already set the
environment by then.
--
Yours,
Jonathan Leffler ([EMAIL PROTECTED]) #include <disclaimer.h>
Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
"I don't suffer from insanity; I enjoy every minute of it!"
