RE: DBI on Win2K
Stephen,
Indeed when I added the line to my script the result was there was no
ORACLE_HOME value. Can you help me determine where it is I need to place
this value in order to recognize it? I've already added the filesystem path
to the following registry settings:
\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
and because Oracle 8i provides the use of multiple ORACLE_HOMES (which I do
not use), the ORACLE_HOME value is also in:
\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
... that value being D:\Oracle\Ora81 in both cases - the filesystem path
which describes where the Oracle software was installed.
Thanks,
Jose
-Original Message-
From: Stephen Clouse [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 6:13 PM
To: Jose Aguayo
Cc: '[EMAIL PROTECTED]'
Subject: Re: DBI on Win2K
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Oct 01, 2001 at 10:37:59AM -0700, Jose Aguayo wrote:
> Can't connect to : Error while trying to retrieve text for error ORA-03121
This virtually always means that $ENV{ORACLE_HOME} is set wrong. Either
it's
incorrect altogether, or the value is not being passed into the environment
for
the Perl interpreter.
I'd recommend putting this at the top of your program to confirm the value
is
what you think it is *when the program runs*. A discrepancy should lead you
to
investigate why your shell is malfunctioning when launching programs.
BEGIN { print "ORACLE_HOME = $ENV{ORACLE_HOME}\n" }
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO7kUhAOGqGs0PadnEQKHdgCfSuoKWXNeDQuu3WUw48yyMT5ESO0AoPqK
QXqdxFt2TGGrXhe9XxPGtGox
=IOwq
-END PGP SIGNATURE-
RE: DBI on Win2K
What is $datasource. Looks like an empty string, that's why it's not
printing it.
Ilya
> -Original Message-
> From: Arjan van Ham [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 01, 2001 9:23 PM
> To: Stephen Clouse; Jose Aguayo
> Cc: [EMAIL PROTECTED]
> Subject: Re: DBI on Win2K
>
>
>
> The error message is:
>
> Can't connect to : Error while trying to retrieve text for error
> ORA-03121
>
> The source is:
>
> use DBI;
> $db = DBI->connect("dbi:Oracle:$sid", $username, $password,
> {AutoCommit
> =>
> 0, PrintError => 0}) || die "Can't connect to $data_source:
> $DBI::errstr";
> $db->disconnect();
>
> Shouldn't it print the value of $data_source before generating
> $DBI::errstr
> in the output ?
>
>
>
> - Original Message -
> From: "Stephen Clouse" <[EMAIL PROTECTED]>
> To: "Jose Aguayo" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, October 01, 2001 6:12 PM
> Subject: Re: DBI on Win2K
>
>
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Mon, Oct 01, 2001 at 10:37:59AM -0700, Jose Aguayo wrote:
> > > Can't connect to : Error while trying to retrieve text for error
> ORA-03121
> >
> > This virtually always means that $ENV{ORACLE_HOME} is set wrong. Either
> it's
> > incorrect altogether, or the value is not being passed into the
> environment for
> > the Perl interpreter.
> >
> > I'd recommend putting this at the top of your program to
> confirm the value
> is
> > what you think it is *when the program runs*. A discrepancy should lead
> you to
> > investigate why your shell is malfunctioning when launching programs.
> >
> > BEGIN { print "ORACLE_HOME = $ENV{ORACLE_HOME}\n" }
>
Re: DBI on Win2K
The error message is:
Can't connect to : Error while trying to retrieve text for error
ORA-03121
The source is:
use DBI;
$db = DBI->connect("dbi:Oracle:$sid", $username, $password, {AutoCommit
=>
0, PrintError => 0}) || die "Can't connect to $data_source:
$DBI::errstr";
$db->disconnect();
Shouldn't it print the value of $data_source before generating $DBI::errstr
in the output ?
- Original Message -
From: "Stephen Clouse" <[EMAIL PROTECTED]>
To: "Jose Aguayo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 01, 2001 6:12 PM
Subject: Re: DBI on Win2K
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Mon, Oct 01, 2001 at 10:37:59AM -0700, Jose Aguayo wrote:
> > Can't connect to : Error while trying to retrieve text for error
ORA-03121
>
> This virtually always means that $ENV{ORACLE_HOME} is set wrong. Either
it's
> incorrect altogether, or the value is not being passed into the
environment for
> the Perl interpreter.
>
> I'd recommend putting this at the top of your program to confirm the value
is
> what you think it is *when the program runs*. A discrepancy should lead
you to
> investigate why your shell is malfunctioning when launching programs.
>
> BEGIN { print "ORACLE_HOME = $ENV{ORACLE_HOME}\n" }
Re: DBI on Win2K
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Oct 01, 2001 at 10:37:59AM -0700, Jose Aguayo wrote:
> Can't connect to : Error while trying to retrieve text for error ORA-03121
This virtually always means that $ENV{ORACLE_HOME} is set wrong. Either it's
incorrect altogether, or the value is not being passed into the environment for
the Perl interpreter.
I'd recommend putting this at the top of your program to confirm the value is
what you think it is *when the program runs*. A discrepancy should lead you to
investigate why your shell is malfunctioning when launching programs.
BEGIN { print "ORACLE_HOME = $ENV{ORACLE_HOME}\n" }
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc.
RE: DBI on Win2K
Actually yes -
c:\sqlplus $user@$sid
works fine. Also, registry indicates:
MyComputer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 --> Oracle_Home variable
is set to the proper filesystem path. Any other ideas?
Jose
-Original Message-
From: Dan Horne [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 1:19 PM
To: Jose Aguayo; [EMAIL PROTECTED]
Subject: RE: DBI on Win2K
ORA 3121 means that your interface interface driver cannot be found. Does
SQL*Plus work from the MS-DOS/command window? If not, it could be that the
ORACLE_HOME is not set correctly
Dan
-Original Message-
From: Jose Aguayo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 5:38 AM
To: '[EMAIL PROTECTED]'
Subject: DBI on Win2K
ActivePerl Build 629
Oracle 8.1.5 on Solaris
DBI.pm,v 10.32 2000/06/14 20:04:03
After upgrading my Oracle client software from v8.05 to 8.1.5, I get the
following error when trying to run *any* perl script which used to run
flawlessly before:
Can't connect to : Error while trying to retrieve text for error ORA-03121
(DBD: login failed)
It's not a login failure either. Can anyone lend insight to the problem?
Using real variables, I can replicate the problem whenever I run the
following:
use DBI;
$db = DBI->connect("dbi:Oracle:$sid", $username, $password, {AutoCommit =>
0, PrintError => 0}) || die "Can't connect to $data_source: $DBI::errstr";
$db->disconnect();
Regards,
Jose
RE: DBI on Win2K
ORA 3121 means that your interface interface driver cannot be found. Does
SQL*Plus work from the MS-DOS/command window? If not, it could be that the
ORACLE_HOME is not set correctly
Dan
-Original Message-
From: Jose Aguayo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 5:38 AM
To: '[EMAIL PROTECTED]'
Subject: DBI on Win2K
ActivePerl Build 629
Oracle 8.1.5 on Solaris
DBI.pm,v 10.32 2000/06/14 20:04:03
After upgrading my Oracle client software from v8.05 to 8.1.5, I get the
following error when trying to run *any* perl script which used to run
flawlessly before:
Can't connect to : Error while trying to retrieve text for error ORA-03121
(DBD: login failed)
It's not a login failure either. Can anyone lend insight to the problem?
Using real variables, I can replicate the problem whenever I run the
following:
use DBI;
$db = DBI->connect("dbi:Oracle:$sid", $username, $password, {AutoCommit =>
0, PrintError => 0}) || die "Can't connect to $data_source: $DBI::errstr";
$db->disconnect();
Regards,
Jose
RE: DBI on Win2k
If you are trying to compile (make) you must have Visual C++ installed (The same compiler as was used to install Activestate. I assume you are using Activestate if you did not have to use nmake to compile the basic Perl). It is easier to use PPM like has been suggested to you, but if you do compile, and you have Visual C++, then substitute "nmake" everywhere you see 'make' in the instructions. Steve H. -Original Message- From: Neil Lunn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:24 AM To: [EMAIL PROTECTED] Subject: RE: DBI on Win2k Use ppm for ActiveState perl. >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, July 31, 2001 3:34 PM >To: [EMAIL PROTECTED] >Subject: DBI on Win2k > > >Hi all, > >I have installed ActivePerl on windows 2000 and want to >install and configure DBI module. > >After running "perl MakeFile.pl", it requires to run "make" > >I think, "make" is for Linux platform and not for Windows. >What should i need to run ?? > >If i require that utility to be downloaded from net, please >also provide me the hyperlink. > >Thanx in advance > >Denis > __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
RE: DBI on Win2k
Use ppm for ActiveState perl. >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, July 31, 2001 3:34 PM >To: [EMAIL PROTECTED] >Subject: DBI on Win2k > > >Hi all, > >I have installed ActivePerl on windows 2000 and want to >install and configure DBI module. > >After running "perl MakeFile.pl", it requires to run "make" > >I think, "make" is for Linux platform and not for Windows. >What should i need to run ?? > >If i require that utility to be downloaded from net, please >also provide me the hyperlink. > >Thanx in advance > >Denis > __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
