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 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.
Regards,
Philip
