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
my $dsn = 'dbi:Oracle:host=grill-name;sid=pork-roast;port=1525';
From: Malka Cymbalista [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 2:28 AM
To: modperl@perl.apache.org; dbi-users@perl.org
Subject: Connecting to
lto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 2:28 AM
To: modperl@perl.apache.org; dbi-users@perl.org
Subject: Connecting to more than one oracle database
I am running Apache 2.0.55 with mod_perl 2.0.1 and Perl 5.8.1 on
a Sun Solaris mac
I am running Apache 2.0.55 with mod_perl 2.0.1 and Perl 5.8.1 on a Sun
Solaris machine. I am using DBI/DBD to connect to an Oracle database. I
am running DBI 1.39 and DBD-Oracle 1.16.
In order to connect to an oracle database on a different machine I have
a tnsnames.ora file with the appropriat
