DBD::Oracle for Oracle 9.2

[Kiko]

Hi everybody,

i'm new to using Perl to connect to Oracle.
I use Perl through Windows, not through Unix or Linux.

While trying to connect to an Oracle database, I keep getting an error
about DBI CONNECT () FAILING.
I did some research and found that it might have to do with DBD::Oracle
being set to work against Oracle 8, and not 9.
If this is the case, what can I do to fix this?
Thanks everybody.

[sco...@pythian.com]

Kiko wrote:
> Hi everybody,
>
> i'm new to using Perl to connect to Oracle.
> I use Perl through Windows, not through Unix or Linux.
>
> While trying to connect to an Oracle database, I keep getting an error
> about DBI CONNECT () FAILING.

Can you post the error.

> I did some research and found that it might have to do with DBD::Oracle
> being set to work against Oracle 8, and not 9.
> If this is the case, what can I do to fix this?
> Thanks everybody.

What version of Perl, DBI, and DBD are you usieng.

[Kiko]

Hey Thanks

Here is the Error:
"DBI connect('host=E06K03;sid=spspsdw','r1aabw',...) failed: at SDW
Oracle Connect.pl line 11
Use of uninitialized value in concatenation (.) or string at SDW Oracle
Connect.pl line 11.
Database connection not made: at SDW Oracle Connect.pl line 11."

Line 11 is:
my $dbh = DBI->connect( 'dbi:Oracle:host=E06K03;sid=spspsdw',
'r1aabw',
'Peru1978'
) || die "Database connection not made: $DBI::errstr";

Perl is 5.6.1
DBI is 1.34
DBD-Oracle is 1.12

And I install modules via Activestate PPM (not through compiling and
makefile)

Thanks

[Kiko]

Any clues guys? Thanks a lot!

[tim....@gmail.com]

The $DBI::errstr is getting lost before connect() returns. That bug was
fixed around DBI 1.43 (July 2004). You're using a DBI that's almost 3
years old, and your DBD::Oracle is 4 years old.

[Kiko]

Hi Tim
Thanks a lot! I really appreciate.