Help with DBI <***

[Robert Bond]

Hi -


I've been trying to upgrade my version of DBI.  My database is Oracle
8.1.7.  When I run the test script shown below I get the following error
message:

Error Message:
*************************
DBI->connect(nhup.mccoy) failed: (UNKNOWN OCI STATUS 1804) OCIInitialize.
Check ORACLE_HOME and NLS settings etc. at test2.pl line 14

I've tried setting the ORACLE_HOME and that doesn't do anything.  Has
anyone seen this before? What is OCI status 1804?

Thanks,
Robert
Software Engineer

Script
============================
use DBI;
  # Environmental variables used by Oracle
$ENV{ORACLE_SID}   = "sid";
$ENV{ORACLE_HOME}  = "/oracle/home";
$ENV{EPC_DISABLED} = "TRUE";
$ENV{ORAPIPES} = "V2";
my $dbname = "xxxx";
my $dbuser = "user";
my $dbpass = "passwd";

  my $dbh = DBI->connect("dbi:Oracle:$dbname", $dbuser, $dbpass)
    || die "Unale to connect to $dbname: $DBI::errstr\n";

my $sql = qq{ SELECT * FROM dual };
my $sth = $dbh->prepare( $sql );
$sth->execute();
$dbh->disconnect();


+------------------------------------------------------------------------+
Robert S. Bond
email     :  [EMAIL PROTECTED]
+------------------------------------------------------------------------+