Satish, Unfortunately, you're in for some difficulty. The last time I checked, due to Oracle's (IMHO ridiculous) licensing restrictions, DBD::Oracle cannot be distributed compiled and ready to install e.g. in a ppm package. Instead, you (officially) have to download it in source format and then compile. Not that compilation is hard (it's trivial), but you have to have a windows system with a C++ compiler and the Oracle libraries - most windows boxes don't have a compiler.
Anyway, I did some googling, and found some references to the same problem, one of which also included the address of a site with an unofficial binary version you can download and install via ppm. Rather than repeating the address and instructions, here's a link to the page: http://www.mail-archive.com/[email protected]/msg17787.html I installed it using active perl 5.8.3 (it works fine), but they also appear to have versions for 5.8.2 and 5.8.4. Hope this helps, Barry > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:activeperl- > [EMAIL PROTECTED] On Behalf Of Waghmare, Satish (IE03x) > Sent: Monday, January 17, 2005 01:55 AM > To: [email protected] > Cc: [EMAIL PROTECTED] > Subject: Oracle connection - Perl > > 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 *********************************************************************************** This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of e-mail transmission. If verification is required, please request a hard-copy version from the sender. *********************************************************************************** _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
