Hi, All, newbie is trying to learn to use Perl DBI/DBD on my computer (Windows 2000)
to update Oracle Database. I have been using ActivePerl 5.6.1 for about 6 months, it
was installed on c:\perl by the MSI(MS Installer) . These are what I did yesterday
1. Used PPM to install DBI (v1.27 from activeperl.com);
2. Used PPM to install DBD-Oracle(v1.06 from activeperl.com)
and then I have the following script for the simple test.pl to run:
=================================
use DBI;
my $dbh = DBI->connect("dbi:Oracle:host=ip.of.the.server;sid=sid_name", "username/pwd"
)
or die "ERR: Cannot connect to database [$db]\n";
=================================
ran the test (perl test.pl) and then got the following error:
---Can't locate object method "connect" via package "DBI" (perhaps you forgot to load
"DBI"?) at test.pl line 10
After that, I tried to install the DBI/DBD by myself:
1. download DBI-1.30.tar.gz from cpan.org; went through unzip->perl
makefile.pl->nmake->nmake test->nmake install successfully;
2. download DBD-Oracle-1.12.tar.gz from cpan.org; I renamed the unzip folder from
"DBD-Oracle-1.12" to "DBD-Ora" because otherwise I could not "cd DBD-Oracle-1.12" nor
"cd DBD-Or~1". When I tried to generate the makefile by doing "perl makefile.pl" it
gave me a error:
---DBI does not define $DBI::VERSION--version check failed at makefile.pl line 20
BEGIN failed--compilation aborted at makefile.pl line 20.
3. Then I went to the DBD folder's makefile.pl line 20:
=====
# This DBI must be installed before we can build a DBD.
# For those not using Dynamic loading this means building a
# new static perl in the DBI directory by saying 'make perl'
# and then using _that_ perl to make this one.
use DBI 1.30;
=====
4. So, I went back and tried to do the "nmake perl" in the DBI directory as suggested,
but the build is stopped in the middle with the following message:
--- NMAKE: fatal error U1095: expanded command line 'C:\Perl\bin\perl.exe -Iblib\arch
-Iblib/lib -I......... ' too long Stop.
--- NMAKE: fatal error U1077: 'C:\WinNT\system32\cmd.exe' return code '0x2' Stop.
The nmake.exe is 1.15 just downloaded from Microsoft site.
What I have done wrong? Any suggestions is appriciated.
TIA,
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
