Hi All , I need some help with DBI. This is the first time I am working with DBI module and am pretty new to perl too. I am trying to connect to a database to execute some queries. I had written a code which is shown below (It is actually a partial code for just connecting to database). I am getting errors which I have pasted below. I believe that it might be due to my lacking some modules but I have turned to you gurus to confirm that and how can I overcome that. Actually this code would be executed at multiple boxes so installing the absent packages may not be a feasible solution. Thanks for any help. Code -------- #!/opt/3d/bin/perl use strict ; use warnings ; use DBI ; my $database_name ; my $data_source ; my $dbh ; my $username ; my $password ; ## I have got my username and password here ## $database_name = $ENV{ORACLE_SID} ; #This contains the ORACLE_SID to which I need to connect $data_source = "dbi:DriverName:database_name" ; $dbh = DBI->connect($data_source , $username , $password) or die $DBI::errstr ; $dbh->disconnect ;
Errors --------- install_driver(DriverName) failed: Can't locate DBD/DriverName.pm in @INC (@INC contains: /opt/3d/dc0579/lib/perl5/5.8.0/aix-thread- multi /opt/3d/dc0579/lib/perl5/5.8.0 /opt/3d/dc0579/lib/perl5 /opt/3d/dc0579/lib/perl5/site_perl/5.8.0/aix-thread-multi /opt/3d/dc05 79/lib/perl5/site_perl/5.8.0 /opt/3d/dc0579/lib/perl5/site_perl /opt/3d/lib/perl5/5.8.0/aix-thread-multi /opt/3d/lib/perl5/5.8.0 /op t/3d/lib/perl5/site_perl/5.8.0/aix-thread-multi /opt/3d/lib/perl5/site_perl/5.8.0 /opt/3d/lib/perl5/site_perl .) at (eval 1) line 3. Perhaps the DBD::DriverName perl module hasn't been fully installed, or perhaps the capitalisation of 'DriverName' isn't right. Available drivers: CSV, ExampleP, File, Oracle, Proxy. at ./sql_exec.pl line 20 Thanks and Regards Nand Kishore S Nand Kishore Sagi ART Support Team 612-304-6917/612-375-2364