I'd first like to confirm that someone has been able to get the following items to work together.
Red Hat Linux 9 Apache 2.0.40 Perl 5.8 DBD-Oracle-1.14 perl-DBI-1.32-5 glibc-2.3.2-27.9
Oracle 8.1.7.0 (on Solaris 7 server)
There were problems compiling the DBD but finally got it to compile and test.pl seemed to work.
We are not trying to do anything fancy and my test code simply connects and disconnects (below).
We seem to get an attempt to connect to the database but then this error:
Database connection not made: OR
A-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) at /var/www/cgi-bin/pftester.cgi line 27. at /usr/lib/perl5/
5.8.0/CGI/Carp.pm line 301
Here is the sample perl for connecting to the database. $ORACLE_HOME is set to the Solaris home for Oracle.
use strict; use DBI; use CGI::Carp 'fatalsToBrowser'; #can help debug use CGI qw(param); my $db = "dbi:Oracle:host=server3.cancer.umn.edu:CCD"; my $db_user = "member"; my $db_user_pw = "XXX";
BEGIN {
$ENV{ORACLE_HOME} = "/data/dbs2/u01/app/oracle/product/8.1.7";
}my $dbh=DBI->connect($db, $db_user, $db_user_pw) || die "Database connection not made: $DBI::errstr"; $dbh->disconnect(); print "SUCCESS!"; exit;
Thanks for any help at all or pointers to more help. -- Peter Fleck Webmaster | University of Minnesota Cancer Center Dinnaken Office Bldg. 925 Delaware St. SE Minneapolis, MN 55414 612-625-8668 | [EMAIL PROTECTED] | www.cancer.umn.edu Campus Mail: MMC 806
