Thank you all for your help. The problem is on not setting Oracle
environment variables. I am free to fly now.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 9:52 AM
To: [EMAIL PROTECTED]
Subject: RE: Please Help on dbi:Oracle
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:Oracle:database_name
This works if
When you reply to a message, please include at least part
of the message so we know what issue you are responding
to.
Read the perldocs for the DBD::Oracle module - do
perldoc DBD::Oracle
at a command prompt. That will show you.
--
Hardy Merrill
Red Hat, Inc.
Kuang, Jeff - Raleigh, NC [EMA
What do you use for dns then?
I tried:
dbi:Oracle:
dbi:Oracle:database_name
with single/double quotes and the same message shown.
On Wed, Oct 22, 2003 at 03:04:18PM -0500, Kuang, Jeff - Raleigh, NC wrote:
> I already tried both. The variables, $dns, $user_name, and $password,
> are just to show you what I put in my code. They are not actually used.
What do you use for dns then?
> > When I ran the following codes,
> >
> >
Hardy Merrill wrote:
Kuang, Jeff - Raleigh, NC [EMAIL PROTECTED] wrote:
$dbh = DBI->connect('$dns','$user_name','$password') or die "Didn't make
it\n$DBI::errstr\n";
Try changing your single quotes to double quotes, like:
$dbh = DBI->connect("$dns","$user_name","$password")
or
> > $dbh = DBI->connect('$dns','$user_name','$password') or die "Didn't make
> > it\n$DBI::errstr\n";
>
> Try changing your single quotes to double quotes, like:
>
>$dbh = DBI->connect("$dns","$user_name","$password")
> or die "Didn't make it\n$DBI::errstr\n";
>
> I think that migh
- 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-
On Wed, Oct 22, 2003 at 02:28:52PM -0500, Kuang, Jeff - Raleigh, NC wrote:
> OS: NT4 SP6
>
> $dbh = DBI->connect('$dns','$user_name','$password') or die "Didn't make
> it\n$DBI::errstr\n";
The single quotes cause the variable to be seen as literal. So instead
using of the value of $dns to establ
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-Oracle from activestate.com
>
>
>
> Problem:
>
>
>
> When I ran the following codes,
>
>
>
> $dbh = DB
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
11 matches
Mail list logo