Database connection issue from Teamsite server

chicka

Hi There,
I am encountering strange issue while connecting to DB.
"Start connect DB1...
DBI connect('host=XXXXX.YYYY.com;sid=wesr1;port=1521','websx',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at dbd-oracle-testnew.pl line 10"

The perl code is a simple connect program to DB.
my $dbh = DBI->connect( 'dbiracle:host=XXXXX.YYYY.com;sid=wesr1;port=1521', 'websx', 'websx', { RaiseError =
> 1, AutoCommit => 0 }) || die "Database connection not made: $DBI::errstr";

Could you please shed light on this? I tried setting the ORACL_HOME path in perl code. Still no luck on it.

Adam Stoller

Hi There, I am encountering strange issue while connecting to DB. "Start connect DB1... DBI connect('host=XXXXX.YYYY.com;sid=wesr1;port=1521','websx',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at dbd-oracle-testnew.pl line 10" The perl code is a simple connect program to DB. my $dbh = DBI->connect( 'dbiracle:host=XXXXX.YYYY.com;sid=wesr1;port=1521', 'websx', 'websx', { RaiseError = > 1, AutoCommit => 0 }) || die "Database connection not made: $DBI::errstr"; Could you please shed light on this? I tried setting the ORACL_HOME path in perl code. Still no luck on it.

Search the forums - this topic comes up a number of times and has been answered a number of times.

After that, if you still cannot resolve your issue - you'll have to post more of the script - especially the top part that shows your module inclusion and BEGIN block.