Hi DBI users,
I encountered the following problem.
Scripts:
#!/usr/bin/perl -w
BEGIN {
$ENV{ORACLE_HOME}= 'oracle_home';
$ENV{TWO_TASK} = 'T:machine_name:db_name';
}
use strict;
use DBI;
my $user = "user_name";
my $passwd = "pass_word";
my $dbh =
DBI->
: Failure
Quoting "Kuang, Jeff - Raleigh, NC" <[EMAIL PROTECTED]>:
> What do you use for dns then?
Check the fine manual as someone else pointed out `perldoc DBD::Oracle`.
> I tried:
>
> dbi:Oracle:
This uses the instance identified in $ORACLE_SID or $TWO_TASK
> dbi:O
What do you use for dns then?
I tried:
dbi:Oracle:
dbi:Oracle:database_name
with single/double quotes and the same message shown.
- Raleigh, NC
Cc: [EMAIL PROTECTED]
Subject: Re: Please Help on dbi:Oracle: Failure
Kuang, Jeff - Raleigh, NC [EMAIL PROTECTED] wrote:
> OS: NT4 SP6
>
> Perl v5.6.1 with ActiveState build 631
>
> Oracle 9.2.0.1
>
>
>
> Installed modules: most current DBI and DBD-
OS: NT4 SP6
Perl v5.6.1 with ActiveState build 631
Oracle 9.2.0.1
Installed modules: most current DBI and DBD-Oracle from activestate.com
Problem:
When I ran the following codes,
$dbh = DBI->connect('$dns','$user_name','$password') or die "Didn't make
it\n$DBI::errstr\n";
I al