Ben, Do you have at least the Oracle client installed on these boxes? If not, you need to install Oracle; if so, use CPAN to load the modules:
$ cpan CPAN> install DBI CPAN> install DBD::Oracle -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 01, 2007 9:30 AM To: dbi-users@perl.org Subject: Trying to set up DBI for oracle I am trying to set up DBI Oracle stuff on a couple of boxes. One is Ubuntu Feiesty and the other is running SunOS 5.8. I have been using the following test script. #!/usr/bin/perl use DBI; $dbh = DBI->connect( "dbi:Oracle:gen3", "user", "pass" ); Linux ------- I get: install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at (eval 3) line 3. Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'Oracle' isn't right. Available drivers: DBM, ExampleP, File, Proxy, Sponge. at ./db.pl line 5 SunOS ---------- I get: install_driver(Oracle) failed: Can't load '/opt/local/perl/5.6.1/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/ Oracle.so' for module DBD::Oracle: ld.so.1: db.pl: fatal: libclntsh.so.8.0: open failed: No such file or directory at /opt/local/perl/5.6.1/lib/5.6.1/sun4-solaris/DynaLoader.pm line 206. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at ./db.pl line 5 Which I guess are both similar errors. Anyone know what the modules I need and how to add them. I am a perl newbee. Regards, Ben -- Ben Edwards - Bristol, UK If you have a problem emailing me use http://www.gurtlush.org.uk/profiles.php?uid=4 (email address this email is sent from may be defunct) This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
