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 |