List Info

Thread: error while using DBD::Oracle




error while using DBD::Oracle
user name
2006-12-06 21:29:07
Hello all,

I am new to perl programming and will appreciate your help
in resolving a error I get while using the DBD::Oracle
module. Some of the information in my question may be very
primitive, please ask me for more details.
I installed Activestate perl 5.8.8 build on my win 2000
desktop. I am trying to run a script listdsns.pl that I got
off the internet at http://www.oreilly.com/catalog/perldbi/chapter/ch04.html

The following script lists all the drivers and data sources
for each driver on your system: 

#!/usr/bin/perl -w
#
# ch04/listdsns: Enumerates all data sources and all
installed drivers
#
use DBI;
 
### Probe DBI for the installed drivers
my drivers = DBI->available_drivers();
 
die "No drivers found!n" unless drivers;
# should never happen
 
### Iterate through the drivers and list the data sources
for each one
foreach my $driver ( drivers ) {
    print "Driver: $drivern";
    my dataSources = DBI->data_sources( $driver );
    foreach my $dataSource ( dataSources ) {
        print "tData Source is $dataSourcen";
    }
    print "n";
}
 
exit;

When I run this script I get the output:
Driver: Oracle
install_driver(Oracle) failed: Can't locate loadable object
for module DBD::Oracle in INC (INC contains: C:Program
FilesActiveState Perl Dev Kit 6.0lib C:Perllib
C:Perl/MSWin32-x86-multi-thread C:Perl C:/Perl/site/lib
C:/Perl/lib .) at (eval 13) line 3Compilation failed in
require at (eval 13) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully
installed at listdsns.pl line 15

How do I know what module DBD:Oracle is looking for. I
downloaded the DBD-Oracle-1.19.tar.gz and copied the
contents to C:perllib directory.

Please help.
_______________________________________________
Perl-Win32-Database mailing list
Perl-Win32-Databaselistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs
error while using DBD::Oracle
user name
2006-12-06 23:35:38
Sethi, Gaurav Ashok wrote:

> When I run this script I get the output:
> Driver: Oracle
> install_driver(Oracle) failed: Can't locate loadable
object for module DBD::Oracle in INC (INC contains: C:Program
FilesActiveState Perl Dev Kit 6.0lib C:Perllib
C:Perl/MSWin32-x86-multi-thread C:Perl C:/Perl/site/lib
C:/Perl/lib .) at (eval 13) line 3Compilation failed in
require at (eval 13) line 3.
> Perhaps a module that DBD::Oracle requires hasn't been
fully installed at listdsns.pl line 15
> 
> How do I know what module DBD:Oracle is looking for. I
downloaded the DBD-Oracle-1.19.tar.gz and copied the
contents to C:perllib directory.

You should build this module (README.win32.txt file contains
detailed 
instructions) or get PPM distribution, using ppm install
DBD::Oracle

-- 
Serguei Trouchelle
_______________________________________________
Perl-Win32-Database mailing list
Perl-Win32-Databaselistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )