Hi,
Install the oracle client on machine B and compile/install the
DBD-Oracle module. You don't need to have a database or all the software
on Machine B but you do need the client software to talk to Oracle. If
you search the list archive, you can find out a list of files you need to
have.
Cheers,
Michael
On Wed, 11 Jul 2001, Shashi Shina wrote:
> Date: Wed, 11 Jul 2001 15:41:05 +0200
> From: Shashi Shina <[EMAIL PROTECTED]>
> 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
>
>
>
