Hello, I am trying to write a perl script to connect to our DB2 database and do some basic SQL queries. But I'm having trouble with making everything play nice. I'm on WinXP, and did a manual build of DBI with Visual Studio's nmake. That all went fine (as far as I can tell). So I downloaded the DBD::DB2 module and unzipped it to my C:/Perl/lib directory (creating the blib directory from the use lib line below. Here's the code I'm trying to test it with...
use lib 'c:/Perl/lib/blib/lib/Bundle'; 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: $driver\n"; my @dataSources = DBI->data_sources( $driver ); foreach my $dataSource ( @dataSources ) { print "\tData Source is $dataSource\n"; } print "\n"; } And here is the output: DBD::DB2 initialisation failed: Can't locate object method "driver" via package "DBD::DB2" at c:/Perl/site/lib/DBI.pm line 768. Perhaps the capitalisation of DBD 'DB2' isn't right. At C:..........dbQueryAutoBatch.pl line 33. Not sure if DBI or DBD::DB2 arne't right or I'm just calling something wrong. But any help would be appreciated. Thanks, KW Kevin Wendt Summer Project Intern Cell: 612-209-2022 Email: [EMAIL PROTECTED] This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation