sorry for direct mail but my post to users
group "[EMAIL PROTECTED]" is bouncing even though
I'm getting all posts - perhaps you can
help with that. Anyway:
------------------------------------
Update on earlier message ( attached ) which
did not go through to users group:
Have new install of perl & new install
of oracle win2k. Oracle works fine in
sqlplus & other utilities. test script works
on other win32 hosts. How can I start
debugging this thing? Stepping through it
in perl -d it just quits in call to DBI.pm.
How can I know whether this is an oracle networking
thing or a perl instance thing or missing DLL
windows thing ( although the OS & machine are
brand new from factory) ? Doing "ppm query"
looks identicle to the other working win32 intance
of same version of perl on same OS.
-------------------------------------------------
the error:
-------------------------------------------------
C:\>perl beth-template3.pl
ORACLE4
install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' fo
r module DBD::Oracle: load_file:A dynamic link library (DLL) initialization routine
failed
at C:/Perl/lib/DynaLoader.pm line 200.
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 beth-template3.pl line 8
--------------------------------------
version, module & config info:
-------------------------------------
C:\>ppm query
Archive-Tar [0.072 ] module for manipulation of tar archives.
CGI [2.74 ] Simple Common Gateway Interface Class
Compress-Zlib [1.08 ] Interface to zlib compression library
DBD-Oracle [1.06 ] Oracle database driver for the DBI module
DBI [1.14 ] Database independent interface for Perl
Digest-MD5 [2.11 ] Perl interface to the MD5 Algorithm
File-CounterFile [0.12 ] Persistent counter class
Font-AFM [1.18 ] Interface to Adobe Font Metrics files
HTML-Parser [2.23 ] SGML parser class
HTML-Tree [0.51 ] HTML syntax tree builder
MIME-Base64 [2.11 ] Encoding and decoding of base64 strings
PPM [2.1.2 ] Perl Package Manager: locate, install, upgrade
software packages.
SOAP-Lite [0.43 ] Library for Simple Object Access Protocol (SOAP)
clients and servers in Perl
URI [1.09 ] Uniform Resource Identifiers (absolute and relative
XML-Element [1.07 ] Base element class for XML elements
XML-Parser [2.27 ] A Perl module for parsing XML documents
libnet [1.07.03] Collection of Network protocol modules
libwin32 [0.17.2 ] A collection of extensions that aims to provide
comprehensive access to the Windows API. libwww-perl [5.48 ]
Library for WWW access in Perl
-----------------------------------------------
C:\>perl -v
This is perl, v5.6.0 built for MSWin32-x86-multi-thread
(with 1 registered patch, see perl -V for more detail)
Copyright 1987-2000, Larry Wall
Binary build 623 provided by ActiveState Tool Corp. http://www.ActiveState.com
Built 16:27:07 Dec 15 2000
-----------------------------------------
C:\>ppm
PPM interactive shell (2.1.2) - type 'help' for available commands.
PPM> verify
Package 'Archive-Tar' is up to date.
Package 'CGI' is up to date.
Package 'Compress-Zlib' is up to date.
Package 'DBD-Oracle' is up to date.
Package 'DBI' is up to date.
Package 'Digest-MD5' is up to date.
Package 'File-CounterFile' is up to date.
Package 'Font-AFM' is up to date.
An upgrade to package 'HTML-Parser' is available.
An upgrade to package 'HTML-Tree' is available.
Package 'MIME-Base64' is up to date.
Package 'PPM' is up to date.
An upgrade to package 'SOAP-Lite' is available.
Package 'URI' is up to date.
Package 'XML-Element' is up to date.
Package 'XML-Parser' is up to date.
Package 'libnet' is up to date.
Package 'libwin32' is up to date.
Package 'libwww-perl' is up to date.
PPM>
---------------------------------------------------
test code & initial post :
----------------------------------------------------
Can't tell which is misconfigured. Perl DBI
or Oracle instance! How do I validate perl install by calling another
networked oracle instance from this perl installation to see if it connects
to another instance? Anyone have pointer to steps & binaries which
flawlessly installs perl dbi on windows. I'm using the orielly CD from the
win32 lizard book which has worked fine on other systems (but is 2 yrs old).
The script ( below) works fine on other oracle/perl/DBi windows installations.
------------------------------------
#
use DBI;
print $ENV{ORACLE_SID};
print "\n";
print "\n";
my $dbh = DBI->connect('DBI:Oracle:ora3.dnax','scott','tiger',\%attr)
or die "Couldn't connect to database: " . DBI->errstr;
my $sth = $dbh->prepare('select * from emp where ename = ?')
or die "Couldn't prepare statement: " . $dbh->errstr;
print "If name present, will print HIREDATE and ENAME\n";
print "\n";
print "Enters row tuple for ename here > ";
while ($ename = <>) { # Read input from Beth
my @data;
chomp $ename;
print "1\n";
$sth->execute($ename) # Execute the query
or die "Couldn't execute statement: " . $sth->errstr;
# Read matching records and print 'em out
while (@data = $sth->fetchrow_array()) {
my $lasttname = $data[1];
my $id = $data[4];
print "2\n";
print "\t$id: $ename $lastname \n";
}
if ($sth->rows == 0) {
print "3\n";
print "No names matched `$ename'.\n\n";
}
$sth->finish;
print "\n";
print "Enter name> ";
}
$dbh->disconnect;
------------------------------------------------------
