RE: Connecting to more than one Oracle database

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
.

Relevant Pages

  • Re: Need guidance
    ... Close all databases that are being shared by FM7 sever. ... Open FM7 pro 7 to execute a script that will import data from another file ... Open all databases in FM7 server to be shared. ...
    (comp.databases.filemaker)
  • Reverting to previous found set from script
    ... Hi guys and girls ... I'm new to FileMaker but not to databases in general. ... So the principles behind relational database operation aren't a problem for me to understand; what I'm having difficulty with is making FileMaker's script steps duplicate what I can do manually. ... If I am in a found set of records, or indeed am looking at all of them, when I click into find mode and enter something which I know can't be found, FileMaker presents an error message and allows me to continue or cancel. ...
    (comp.databases.filemaker)
  • Re: Script for your enjoyment
    ... Another environment specific aspect. ... I do not maintain any databases ... The script should do that for you. ... isn't anyone checking if a domain group exists before they add it". ...
    (microsoft.public.scripting.wsh)
  • Re: Automating results to file in script
    ... For generating script files you might be better of using the osql command ... You can specify a script as the input file (-i ... However, if you want to backup all databases, you might want to have a look ...
    (microsoft.public.sqlserver.programming)
  • Re: HTTP 403
    ... just saying HTTP 403. ... you've done it correctly) is that the first time it gets executed, ... Just the follow question as above - can I in your script use the input ...
    (comp.lang.php)