I got this same error and have seen others post with the same problem. I
d/l'd the whole oracle kit (dbd-oracle-1.14, from cpan) and built it on my
machine, and it works fine (DBI doesn't have any .dll dependencies that
I'm aware of). I have the full oracle 8.1.4 client installed, MSVC 6 SP3,
and perl 5.8.2 build 808 (ActiveState) on XP Pro. The commands I used (in
a command window) were: vcvars32.bat (configures command-line MSVC
environment), perl Makefile.pl (complained about not being able to find
Oracle headers), nmake (worked despite prev warning), nmake install.
If someone has some info on how I can bundle this up, I'd be happy to do
it. My concern is with the various pieces that I used, however. I don't
really have access to any other Oracle clients and I don't know what the
DLL hell would look like if I tried to ship this.
Dave
On Dec 29, Capacio, Paula J scribed:
> 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.
>
