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
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:
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
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
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
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
