I just installed ActivePerl 5.8.1.807 on a WinXP box.
I downloaded and installed DBI 1.37 and DBD-Oracle 1.13 from
ftp.esoftmatic.com without incurring any errors.
However, when attempting to run this code:
#code snippet
use DBI;
$dbh = DBI->connect("dbi:Oracle:host=hxddba01;sid=mp3u", 'scott',
'tiger')
or die "connect failed: $DBI::errstr\n";
print "If this prints...you are connected\n";
$dbh->disconnect;
#End of Code
I get a pop-up box titled: perl.exe - Entry Point Not Found
which states: The procedure entry point Perl_Glockhook_ptr could
not be located in the dynamic link library perl58.dll.
Must click OK, at which point the command window displays this error:
install_driver(Oracle) failed:
Can't load 'C:/Perl58/site/lib/auto/DBD/Oracle/Oracle.dll'
for module DBD::Oracle: load_file:
The specified procedure could not be
found at C:/Perl58/lib/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at u:\perl_info\oraconn_woTNSnames.pl line 2
I have tried copying the Oracle.dll to c:/perl58/bin --> didn't work.
Also tried adding C:/Perl58/site/lib/auto/DBD/Oracle
to my system PATH variable...no luck.
The Oracle client is installed and works correctly, via SQL*Plus.
Also ActivePerl5.6.1 Build 630 is installed in a separate directory
on this XP box, it has DBI 1.14 and DBD-Oracle 1.06 and works
perfectly with the code snippet above, so the problem has to be
with the installation of 5.8 and the modules.
Here's the PPM output from the module installs:
###PPM output###
Installing module DBI
====================
Install 'DBI' version 1.37 in ActivePerl 5.8.1.807.
====================
Successfully installed DBI version 1.37 in ActivePerl 5.8.1.807.
Installing C:\Perl58\site\lib\auto\DBI\dbd_xsh.h
Installing C:\Perl58\site\lib\auto\DBI\DBI.bs
Installing C:\Perl58\site\lib\auto\DBI\DBI.dll
Installing C:\Perl58\site\lib\auto\DBI\DBI.exp
Installing C:\Perl58\site\lib\auto\DBI\DBI.lib
Installing C:\Perl58\site\lib\auto\DBI\dbipport.h
Installing C:\Perl58\site\lib\auto\DBI\DBIXS.h
Installing C:\Perl58\site\lib\auto\DBI\dbi_sql.h
Installing C:\Perl58\site\lib\auto\DBI\Driver.xst
Installing C:\Perl58\site\lib\auto\DBI\Driver_xst.h
Files found in blib\arch: installing files in blib\lib into
architecture dependent library tree
Installing C:\Perl58\site\lib\DBI.pm
Installing C:\Perl58\site\lib\Bundle\DBI.pm
Installing C:\Perl58\site\lib\DBD\ExampleP.pm
Installing C:\Perl58\site\lib\DBD\NullP.pm
Installing C:\Perl58\site\lib\DBD\Proxy.pm
Installing C:\Perl58\site\lib\DBD\Sponge.pm
Installing C:\Perl58\site\lib\DBI\Changes.pm
Installing C:\Perl58\site\lib\DBI\DBD.pm
Installing C:\Perl58\site\lib\DBI\FAQ.pm
Installing C:\Perl58\site\lib\DBI\Profile.pm
Installing C:\Perl58\site\lib\DBI\ProfileData.pm
Installing C:\Perl58\site\lib\DBI\ProfileDumper.pm
Installing C:\Perl58\site\lib\DBI\ProxyServer.pm
Installing C:\Perl58\site\lib\DBI\PurePerl.pm
Installing C:\Perl58\site\lib\DBI\W32ODBC.pm
Installing C:\Perl58\site\lib\DBI\Const\GetInfoReturn.pm
Installing C:\Perl58\site\lib\DBI\Const\GetInfoType.pm
Installing C:\Perl58\site\lib\DBI\Const\GetInfo\ANSI.pm
Installing C:\Perl58\site\lib\DBI\Const\GetInfo\ODBC.pm
Installing C:\Perl58\site\lib\DBI\DBD\Metadata.pm
Installing C:\Perl58\site\lib\DBI\ProfileDumper\Apache.pm
Installing C:\Perl58\site\lib\Win32\DBIODBC.pm
Installing C:\Perl58\bin\dbiprof
Installing C:\Perl58\bin\dbiprof.bat
Installing C:\Perl58\bin\dbiproxy
Installing C:\Perl58\bin\dbiproxy.bat
Installing module DBD-Oracle
====================
Install 'DBD-Oracle' version 1.13 in ActivePerl 5.8.1.807.
====================
Successfully installed DBD-Oracle version 1.13 in ActivePerl
5.8.1.807.
Installing C:\Perl58\site\lib\auto\DBD\Oracle\dbdimp.h
Installing C:\Perl58\site\lib\auto\DBD\Oracle\mk.pm
Installing C:\Perl58\site\lib\auto\DBD\Oracle\ocitrace.h
Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.bs
Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.dll
Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.exp
Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.h
Installing C:\Perl58\site\lib\auto\DBD\Oracle\Oracle.lib
Files found in blib\arch: installing files in blib\lib into
architecture dependent library tree
Installing C:\Perl58\site\lib\oraperl.ph
Installing C:\Perl58\site\lib\Oraperl.pm
Installing C:\Perl58\site\lib\DBD\Oracle.pm
Installing C:\Perl58\bin\ora_explain
Installing C:\Perl58\bin\ora_explain.bat
###End of PPM###
Any help will be appreciated. Thanks in advance.
