[EMAIL PROTECTED] wrote:
> After commenting out two lines in our sqlhosts file attempts to use DBI
> errored out with Informix SQL error 25596: The INFORMIXSERVER value is not
> listed in the sqlhosts file.
So, what was the value of $INFORMIXSERVER ($ENV{INFORMIXSERVER})?
Why did you decide to eliminate that entry from the sqlhosts file?
Why does ESQL/C insist that the entry implied by $INFORMIXSERVER is valid even
when you specify the database server in the connect string?
I'm not convinced I care about the answer to the first question; I'm moderately
convinced that the problem is precisely that you removed an entry which was
referenced by $INFORMIXSERVER.
And I'm moderately convinced that there is no good answer to the third
question, because it is a usability bug, but anyway, you have to have
$INFORMIXSERVER set to a valid server even when you specify the server in the
DBI->connect call. I hope to get this fixed eventually, but it make take a
while.
> The lines commented out did not pertain to the
> server to which the connection was attempted nor to the server DBD-Informix
> was built against. After uncommenting the lines DBI connected and returned
> the proper values. It is not unusual in our development environment to
> alter the sqlhosts file which has not impacted accessing those Informix
> servers not affected by the sqlhosts file change from other clients, eg.,
> dbaccess, esql-c, Uniface.
>
> Does DBI require rebuilding DBD whenever the sqlhosts file changes and is
> there someway, eg., specifying a proxy file that will not be changed, to
> avoid this inconvenience?
>
No, the sqlhosts file is completely dynamic. You can even select the name with
the INFORMIXSQLHOSTS environment variable at run time. However, you must have
a valid entry in the sqlhosts file for the value specified by $INFORMIXSERVER,
and you must have $INFORMIXSERVER set in the environment, even if you specify
the required server explicitly in the connect string. And it isn't
DBD::Informix's fault!
> Our system architecture:
> DBI v. 1.15
> DBD-Informix v 1.00.PC1
> Perl v 5.6.1
> Solaris 5.6
> Informix v 7.31UD1
Thanks for the summary info.
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
