As far as I know, you will need to install Oracle client on
machine B in order to compile DBD::Oracle on B.
Regards,
Mahdi.
-----Original Message-----
From: Shashi Shina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 3:41 PM
To: [EMAIL PROTECTED]
Subject: DBD Oracle from remote machine
Hi all,
First of all I am a newbie !
I have Oracle 8.x installed on machine A on Linux (http server Apache).
On the same machine A I have installed DBI and DBD::Oracle.
And I can access oracle from the same machine A with charm. No Problem !
e.g. $dbh = DBI->connect("dbi:Oracle:host=localhost;sid=ORCL", $user,
$passwd);
But my problem is I want to access Oracle on machine A from remote machine
B.
On machine B (Linux, Apache) only DBI is installed.
Now if I use the following
e.g. $dbh = DBI->connect("dbi:Oracle:host=remotehost;sid=ORCL", $user,
$passwd);
it give me error "DBD oracle not installed"
Now, If I try to install DBD::Oracle on machine B, It is giving me error !
It is looking for
Oracle on local machine B itself. So I cannot install DBD::Oracle on machine
B.
Then How can I connect through DBI to Oracle on remote machine??
Do I have to install whole oracle 8.x again on machine B also for installing
DBD::Oracle?
Any help will be highly appreciated !
regards,
Shashi
