RE: Please Help on dbi:Oracle: Failure

2003-10-23 Thread Kuang, Jeff - Raleigh, NC
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

RE: Please Help on dbi:Oracle: Failure

2003-10-23 Thread Michael A Chase
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

Re: Please Help on dbi:Oracle: Failure

2003-10-23 Thread Hardy Merrill
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

RE: Please Help on dbi:Oracle: Failure

2003-10-23 Thread Kuang, Jeff - Raleigh, NC
What do you use for dns then? I tried: dbi:Oracle: dbi:Oracle:database_name with single/double quotes and the same message shown.

Re: Please Help on dbi:Oracle: Failure

2003-10-22 Thread Thomas A. Lowery
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, > > > >

Re: Please Help on dbi:Oracle: Failure

2003-10-22 Thread Jeff Zucker
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

Re: Please Help on dbi:Oracle: Failure

2003-10-22 Thread paul . boutros
> > $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

RE: Please Help on dbi:Oracle: Failure

2003-10-22 Thread Kuang, Jeff - Raleigh, NC
- 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-

Re: Please Help on dbi:Oracle: Failure

2003-10-22 Thread Thomas A. Lowery
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

Re: Please Help on dbi:Oracle: Failure

2003-10-22 Thread Hardy Merrill
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

Please Help on dbi:Oracle: Failure

2003-10-22 Thread Kuang, Jeff - Raleigh, NC
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