Janet, Add an alias entry on your client's (DEC Alpha) tnsnames.ora file for the other Oracle database. Then use the new alias in your connect string.
Hope this helps, Anna -------------------------------------------------------- Anna Q. Fong, Webmaster California Data Exchange Center > -----Original Message----- > From: Janet Goldstein [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 06, 2003 11:17 AM > To: [EMAIL PROTECTED] > Subject: question: DBD::Oracle needed for DBI on another host? > > I am running Perl 5.6.0 on a DEC Alpha. I wish to access an Oracle > database located on a different machine. Do I still need to install > DBD::Oracle locallly (on the machine running the script), or is DBI > enough by itself? > > If DBD::Oracle is required, then at installation do I tell it the > host's ORACLE_HOME and so forth, or what? As it happens, there is an > Oracle database on the local machine running the script, but that's > not the database we want to access.... > > Any help/feedback would be appreciated. Thanks. > > -- > Janet Goldstein, Sr. Programmer/Analyst II > Center for Inherited Disease Research > Johns Hopkins University / Bayview Campus > 333 Cassell Drive / Baltimore, MD 21224 > [EMAIL PROTECTED] / 410-550-2819 / fax 410-550-3559 > http://www.cidr.jhmi.edu/
