Hi: 
Couldn't get correct link to install DBD::Oracle. Help me to get the correct
link where I can get full dounloadable DBD::Oracle package. 
Please see below log after I download it and I tried installing it but
failed to complete.

Thank You
Satish

LOG:-
ppm> install "C:\Documents and
Settings\SatishW\Desktop\ora\DBD-Oracle-1.06\orac
le.pm"
Error: No valid repositories:
Error: 501 Protocol scheme '' is not supported
Error: 501 Protocol scheme '' is not supported
ppm>

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Murugavel
Chidambaram
Sent: Thursday, January 13, 2005 3:07 AM
To: Satish.Waghmare
Cc: [EMAIL PROTECTED];
[email protected]
Subject: Re: Oracle connection - Perl


Hi,

Please make sure DBI (oracle connective  module) is installed on the 
server/PC. If not, please install it before you use it on your scripts. 
Then, it should be OKAY.

Regards

C.M
+++++++++++++++++++++++++++++++++++++++
Statutory Reporting IT, CBTO
Deutsche Securities Limited [/], Tokyo
Work  81-3-5156-7567
Fax   81-3-5156-6023
+++++++++++++++++++++++++++++++++++++++




[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/13/2005 07:32 PM

 
        To:     [EMAIL PROTECTED]
        cc:     [email protected]
        Subject:        Oracle connection - Perl


Hi.. 
I am new to the Perl programming.I am facing a problem with connecting to 
Oracle Database. 
See below script and error log for details.
Please help me. 
Thanks
~Satish
 
My Script: 
 
use DBI;
my %test;
 
$dbh = 
DBI->connect("dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=thl02
DBI->566)(PORT=1529))(CONNECT_DATA=(SID=manthan)))",
'db2admin', 'db2admin', {AutoCommit => 0 } );
 
$sqlstatement="SELECT * FROM solution";
$sth = $dbh->prepare($sqlstatement);
$sth->execute || die "Could not execute SQL statement ... maybe invalid?";
 
#output database results
while (@row=$sth->fetchrow_array()){ 
 #print join('--',$row[0],$row[1], $row[2], "\n");
   print "@row\n";
 
   $test{$row[1].$row[2]} = $row[0];
 
 }
 
print "printing in hash table \n";
 
while(($key,$value) = each %test) {
 print join(" ","Hash Key = ", $key, "Hash Value = ", $value, "\n"); }
 

Error Generated:
 
C:\Perl\bin>perl C:\te.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC 
contains
: C:/Perl/lib C:/Perl/site/lib .) at (eval 1) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps
the capitalisation of 'Oracle' isn't right. Available drivers: ExampleP,
ODBC, Proxy.  at C:\te.pl line 5
 
 _______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs



_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to