I wrote a script on an NT workstation using AS Perl 5.6.1, DBI 1.14, DBD-Oracle 1.06
and it works fine. It's supposed to run on an NT server and it fails there where the
version of perl is 5.005_02, PPM query shows that DBI and DBD are present but does not
give version information. I looked in the directory structure and opened the DBI -
DBD.pm and saw v10.7 and DBD-Oracle show V1.02 rev 1.76. <Duh! my bad didn't consider
version differences>
Can someone help with the nuances between these versions? It's a shared server and
I'd have to get a BUNCH of people involved to upgrade the perl/mods...so I'm first
trying to modify the script.
Here's a snippet of my connect statement....
###
# Username@instanceName
my $connString = $connInfo[1].'@'.$connInfo[0];
# *see above password
my $dbh = DBI->connect('dbi:Oracle:',"$connString","$connInfo[2]")
or processError ("ConnErr",@connInfo);
###
The error I'm getting is:
@��w����"� (DBD: login failed, check ORACLE_HOME/bin is on your PATH)
The system path variable contains C:\Orant815\bin
I tried setting a system variable called ORACLE_HOME to that same value but to no
avail.
BTW, logging in via SQLPLUS with the same connection information works fine so the
Oracle client/TNSNAMES entry is accurate.
Any help would be appreciated.
Paula
