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

#!/fellow/monks.pl

I've developed some DBI applications (on my notebook), and using a DBI connect string like this..

$dbh = DBI->connect("DBI:Oracle:host=$SERVER;sid=$SID", $UID, $PWD);

and it works fine. I put it into production, and the script fails. I then have to change the code like this

$dbh = DBI->connect("DBI:Oracle:host=$SERVER;sid=$SID;uid=$UID;pwd=$PW +D");

What's the deal?

Thanks!

#!/massyn.pl

Don't -- me without telling me why. If you asked a stupid question, I wouldn't down vote you.

Replies are listed 'Best First'.
Re: DBI DSN authentication
by jdtoronto (Prior) on Aug 22, 2003 at 02:02 UTC
    What versions of both DBI and the DBD-Oracle driver are in use on the two machines?

    The first connect looks kosher for recent releases of DBI, but the second sure does not look right!

    jdtoronto