Perl Oracle issue

------_=_NextPart_001_01C5CD9B.D03AA3C2
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I was running DBI on my machine and it was fine.

I was accessing remote Oracle servers using DBD::ORACLE.

But when I had installed Oracle client on my machine .

I am not able to connect to any of the oracle servers using Perl DBI.

Every time I try to connect ,error generated is :

=20

install_driver(Oracle) failed: Can't load
'c:/razat/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module
DBD::Oracle: load_file:The specified procedure could no

t be found at c:/razat/Perl/lib/DynaLoader.pm line 230.

=20

But when I deinstall the Oracle client and try to connect using PERL DBI
, I m able o connect.

I want to know what I have to do to keep both running.

=20

Regards,

=20

Razat

=20

=20

Razat Gupta

=20

=20


------_=_NextPart_001_01C5CD9B.D03AA3C2--

Re: Perl Oracle issue

On Mon, 2005-10-10 at 06:09, Gupta, Razat wrote:
> I was running DBI on my machine and it was fine.
>
> I was accessing remote Oracle servers using DBD::ORACLE.

Which indicates that Oracle was already installed on your machine.
Otherwise, DBD::Oracle would complain.

> But when I had installed Oracle client on my machine .
>

So, now you have 2 copies of Oracle on your machine.
Assuming this is Windows, the new version has taken
precedence in %PATH%.

> I am not able to connect to any of the oracle servers using Perl DBI.

The new version is not compatible with the installed DBI.

Use the Oracle Home Selector to switch Oracle Homes, thereby changing
PATH.

If you installed the 10g client, this will not work.


>
> But when I deinstall the Oracle client and try to connect using PERL DBI
> , I m able o connect.

Ah, you figured that out.


> I want to know what I have to do to keep both running.
>

This is the wrong list. This is not a DBI problem.

Try joining a list such as Oracle-L:
http://www.freelists.org/webpage/oracle-l

Alternatively, you could ask about this at the Usenet Group for Oracle:
http://groups.google.com/group/comp.databases.oracle.server/

That list is sometimes not kind to newbie questions.

Jared