Access to ENV variables in *.ipl called from DCT

TeamSite 5.5.2 Win2K

I have a DCT that calls an *.ipl using 'inline command'. In the *.ipl, I connect to an SQL Server database using
my $dbh = DBI->connect(DBI Smiley Surprised

DBC

BNAME, 'username', 'password') or die "Couldn't connect to database: " . DBI->errstr;

I would like to use ENV vars instead of the literal strings for connect call parameters. However, when I switch to using:
my $dbh = DBI->connect($ENV{DBI_DSN}, $ENV{DB_USR}, $ENV{DB_PWD}') or die "Couldn't connect to database: " . DBI->errstr;
the connect fails.

I had no problem getting this to work when I am connecting from an *.ipl called from a workflow cgitask, but cannot get it working from <inline command>

Find more posts tagged with

Comments

Migrateduser

For whatever reason it seems that the environment is cleared before the inline is called. I think it has been like this since at least 4.2 and I have not found a workaround or an answer from Interwoven for this.

lcarr

Ugh! Do you know if the same is true for accessing ENV vars from <iw_perl> code in *.TPLs and for *.ipl files called from a workflow external task?

Migrateduser

For some reason I think that more environment stuff is available in the presentation template but I would have to test it to be sure. I remember specifically having to set ORACLE_HOME and/or SYSTEM_ROOT or something on Windows to get database calls to work.