in reply to Re: DBI connect('my_dsn','user',...) failed: [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. (SQL-HY000)
in thread DBI connect('my_dsn','user',...) failed: [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. (SQL-HY000)

yes, the file is readable by the web user (same as every other script that works) and yes the INFORMIXDIR is set (On Windows platforms, INFORMIXDIR is a registry setting rather than an environment variable.)
  • Comment on Re^2: DBI connect('my_dsn','user',...) failed: [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. (SQL-HY000)

Replies are listed 'Best First'.
Re^3: DBI connect('my_dsn','user',...) failed: [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. (SQL-HY000)
by albi (Initiate) on Jul 20, 2009 at 18:23 UTC

    I found the solution: while INFORMIXDIR was set in the registries, it also needed to be set in Apache's environment variables, along with a few others.

    I added the followings to httpd.conf: 

    #INFORMIX 
SetEnv INFORMIXDIR "C:/informix32"
SetEnv INFORMIXSERVER "server"
SetEnv DELIMIDENT n
SetEnv DBANSIWARN n
SetEnv CLIENT_LOCAL "en_US.CP1252"
SetEnv DB_LOCAL "en_US.CP1252"

    [download]
    and then restarted Apache.

[reply]
[d/l]

In Section Seekers of Perl Wisdom