kprasanna_79 has asked for the wisdom of the Perl Monks concerning the following question:

Revered Monks

I am using the old version of DBI and i am facing some issues when i connect ORacle using URL and Service name instead of TNS name. Is it because of the version of DBI i am using and hence should i upgrade DBI to the latest?

my $dsn = 'dbi:Oracle:ex01-scan.ch3.prod.i.com:1521/SV01DWHP';

[download]

Please advice
-Prasanna.K

Replies are listed 'Best First'.
Re: Question on DBI
by roboticus (Chancellor) on Sep 28, 2012 at 06:05 UTC

    kprasanna_79:

    When I connect to Oracle (v9) via IP/Port/SID, my connection strings look like:

    my $cnx='dbi:Oracle:host=172.23.xxx.xxx;sid=DEVDB;port=1521;';

    [download]

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]
Re: Question on DBI
by ww (Archbishop) on Sep 28, 2012 at 02:46 UTC
    Old module, understood.

    Did you update Perl and try to continue using the module built for a previous version?

[reply]
Re: Question on DBI (unanswerable)
by Anonymous Monk on Sep 28, 2012 at 02:26 UTC

    Impossible to say

    use DBI->trace(99), get actual diagnostic information

[reply]

Back to Seekers of Perl Wisdom