perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Garrett, Philip \(MAN-Corporate\)" <>
Subject RE: Connecting to more than one Oracle database
Date Mon, 11 Dec 2006 14:27:52 GMT
Malka Cymbalista wrote:
> 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 run from the web it gives very
> inconsistent results.  Sometimes it succeeds in connecting to the
> first database I specify and sometimes it can't connect to either. I
> tried specifying the environment variables ORACLE_SID and TWO_TASK
> from within the script but that didn't seem to help consistently. 
> That is, sometimes it worked and sometimes it didn't and we couldn't
> figure out exactly when it would or would not work.
> Does anyone know how I can connect via the web to 2 different oracle
> databases sitting on 2 different machines from within the same script.

I don't see anything in your example that would prevent you from making
connections to both databases from inside a web server.  At this point,
it would be helpful to post a small program that demonstrates the
problem you're having.


View raw message