problem conencting to oracle after upgrading to oracle 9i

Hi All,


On sparc m/c SUN OS 5.8 , I have recently upgraded from Oracle 8i to Oracle
9i.

ANd I had DBD:Oracle 1.12 installed on it.

Now the perl files give error :
DBI->connect(hemdadev) failed: ERROR OCIEnvInit at test.pl line 18

And at line 17 I have : $dbh = DBI->connect("DBI:Oracle:$sid",$username,
$password) || die "Could not co
nnect to database";

1. If I install DBD::Oracle again specifying the new oracle_home , will I be
able to resolve the error.
2. Is only DBD::Oracle 1.14  compatible with Oracle 9i.

Thanks in advance,
Nilay

"Nilay Puri, Noida" wrote:

> Hi All,
>
> On sparc m/c SUN OS 5.8 , I have recently upgraded from Oracle 8i to Oracl
e
> 9i.
>
> ANd I had DBD:Oracle 1.12 installed on it.
>
> Now the perl files give error :
> DBI->connect(hemdadev) failed: ERROR OCIEnvInit at test.pl line 18
>
> And at line 17 I have : $dbh = DBI->connect("DBI:Oracle

Is that DBI::Oracle, or DBD::Oracle?  They probably are not interchangeable.
  My
bet would be on DBD::Oracle.

Joseph