Home > Archive > PERL Beginners > March 2004 > problem conencting to oracle after upgrading to oracle 9i
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problem conencting to oracle after upgrading to oracle 9i
|
|
| Nilay Puri 2004-03-26, 11:14 pm |
| 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
| |
| R. Joseph Newton 2004-03-26, 11:14 pm |
| "Nilay Puri, Noida" wrote:
> 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
Is that DBI::Oracle, or DBD::Oracle? They probably are not interchangeable. My
bet would be on DBD::Oracle.
Joseph
|
|
|
|
|