Hi,
see if somebody could help me.
I installed DBD-Oracle 1.06 on Oracle 8.1.6 on a Solaris platform.
The installation worked fine. But when I execute a perl program
that call the DBD it gives the following error
DBI->connect(mingus) failed: ORA-12154: TNS:could not resolve service
name (DBD ERROR: OCIServerAttach) at ./delete_sample.pl line 21
Can't call method "prepare" on an undefined value at ./delete_sample.pl
line 26, <STDIN> line 1
The first few lines of my code is as follows:
#!/usr/local/bin/perl
# delete_sample.pl Code to delete samples from the table
# specinfo in polaris database
# as per the user's input
#
use DBI;
my ($dbh, $rows, $stmt, $rc);
$ENV{'ORACLE_HOME'}="/usr/oracle";
$ENV{'ORACLE_SID'}="oracle";
$ENV{'LD_LIBRARY_PATH'}="/usr/oracle/lib";
# Connect to the database
# Change your_dbalias to the SQL*Net V2 alias for your database
# Change username/password to a valid database user/password combination
print "Enter the sample name you want to \ndelete (Use Uppercase
only):";
chop ($sample = <STDIN>);
print "\nConnecting to Database\n\n";
$dbh = DBI->connect("dbi:Oracle:mingus","/", ""); op ($sample =
<STDIN>);
Can anybody help me
Thanks
Resmy
--
*****************************************************************
* Resmy Jason * (215) 728 3660 *
* Oracle Database Administrator * Fax: (215) 728 2513 *
* Research Computing Services * E-mail: [EMAIL PROTECTED] *
* Fox Chase Cancer Center * *
* Philadelphia, PA 19111, USA * *
*****************************************************************
