You could try specifying the host and sid in the connect string.
That way you only need ORACLE_HOME defined, nothing else.
Something like this:
my $dsn = 'dbi:Oracle:host=grill-name;sid=pork-roast;port=1525';
From: Malka Cymbalista [mailto:[EMAIL PROT
If you have a "normal" installation...in particular, your tnsnames.ora
and any whatever other .ora files reside in
$ORACLE_HOME/network/admin/. Then only $ORACLE_HOME need be supplied,
then you can create a connection for every database in your
tnsnames.ora file if you like. If tnsnames.ora resid
Hello to all of you, Last week I sent an email asking how to connect to
more than one remote Oracle database. My problem was that in my
startup.pl file, I am setting the following environment variables:
ORACLE_HOME, ORACLE_SID, TWO_TASK and TNS_ADMIN. If I am trying to
connect to 2 different data
Malka Cymbalista wrote:
I have a script that works from the command line but does not work when
I run it from the web.
Good, you've narrowed it down then. These are the most common sources
of problems that happen only when run from a web server:
- Differences in %ENV
- Running as a differen
Thanks for all those who replied. I solved the problem - there was a
problem with the syntax of the connect command. thanks again.
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
>>> On 12/11/2006 at 9:01 PM, in message <[EMAIL PROTECTED]>,
Perrin Harki
Malka Cymbalista wrote:
[snip]
> I connect in the following manner:
>
> DBI->connect("DBI:Oracle:asdb","user1","password1");
> and
> DBI->connect("DBI:Oracle:asdb2","user2","password2");
>
> I have a script that works from the command line but does not work
> when I run it from the web. When I ru