>>> Andy Squires <[EMAIL PROTECTED]> 01/15/04 10:33AM >>>
<snip>
Anyway, I can't seem to connect to the second database, db2, even when
I set up all the environment
variables to point to the second instance of Oracle. I do know db2 is
using port 1522. It wasn't clear
to me from the documentation in Oracle.pm where to put the port number
in the connection string, or even
if I need to.
Look in the excellent documentation included with the DBI and
DBD::Oracle modules by doing
perldoc DBI
perldoc DBD::Oracle
at a command prompt. 'perldoc DBD::Oracle' will show you how to
connect using the proper port. I'm not sure that this will solve your
problem, but looking in Oracle.pm is the hard way to find the
documentation ;-)
HTH.
Hardy Merrill
-------------------
I am setting ORACLE_SID to the name of the database instance.
Any suggestions? This is using DBD-Oracle 0.59 and Oracle 8.1.7.
Thanks,
Andy
| Andy Squires -- Programmer / Analyst
|
| E-Administration -- American University
|
| (202) 885-2785
|
