-- "Kairam, Raj" <[EMAIL PROTECTED]>
To those who could help me with a problem connecting to an Oracle
database on HP-UX from within a perl script that uses DBI
I have a perl program on a unix (HP-UX) host(A) running Oracle 8.1.6
In the program I am trying to connect to another unix (HP-UX) host(B)
running Oracle 8.1.7 holding a table c1dwg.
The perl script that runs on host A contains these lines.
$ENV{'ORACLE_HOME'} = '/u01/app/oracle/product/8.1.6';
$ENV{'ORACLE_SID'} = 'CAD';
use DBI;
$dbh = DBI->connect('dbi:Oracle:Mycad4prod', '<user>', ''<password') ||
Just for the fun of it try:
my $dbh = DBI->connect
(
"dbi:Oracle:host=$ip_address;sid=$sid",
$user,
$pass
);
The point here is to bypass any other issues and see
if you can reach a tnslsnr on the IP address with an
explicit ORACLE_SID value.
--
Steven Lembark 85-09 90th Street
Workhorse Computing Woodhaven, NY 11421
[EMAIL PROTECTED] 1 888 359 3508
