RE: Oracle/DBI



Razat,

I have only ever built DBD::Oracle from the source you download from CPAN,
and under Windows, I have only done this in a Cygwin environment. It's
pretty straight forward under Cygwin and Linux, but I have never done this
in a 'native' windows environment. I'm pretty sure if you do this you need
a Microsoft C compiler. If you want to go down this path I suggest you
download the source tarball from CPAN and read the instructions contained
therein. However I'm pretty sure there should be a binary available for
Windows somewhere. You could start by searching the archives of this list.

Steve

-----Original Message-----
From: Gupta, Razat [mailto:razat.gupta@xxxxxxxxxxxx]
Sent: Tuesday, 18 October 2005 8:55 PM
To: Steve Baldwin
Subject: RE: Oracle/DBI

Dear Steve,

Can you please give me a brief description of the steps you want me to
follow.
Like : if I m running Oracle Client 8.1.0 .The which version of DBI and
DBD should I follow.


Regards,

Razat

-----Original Message-----
From: Steve Baldwin [mailto:stbaldwin@xxxxxxxxxxxxxxxx]
Sent: Tuesday, October 18, 2005 4:07 AM
To: dbi-users@xxxxxxxx
Subject: RE: Oracle/DBI

Razat,

You must have previously had a different version of the Oracle client.
DBD::Oracle *requires* the SQL*Net client to connect to the DB. If you
installed a later version of the SQL*Net client, you will either need to
re-build DBD::Oracle against that version, or download a version of the
DBD::Oracle binaries that has been built against the correct version of
the
SQL*Net client.

HTH,

Steve

-----Original Message-----
From: Gupta, Razat [mailto:razat.gupta@xxxxxxxxxxxx]
Sent: Tuesday, 18 October 2005 6:50 PM
To: sreenivas reddy
Cc: dbi-users@xxxxxxxx
Subject: RE: Oracle/DBI

Thanks for your response.
But I have installed Perl DBI and DBD::Oracle.
Before installing Oracle client, I was able to connect to Oracle server.
But when I had installed Oracle client, I am not able to connect to it.
I am getting the error mentioned below:

ERROR:


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 n't be found at
c:/razat/Perl/lib/DynaLoader.pm line 230.
Perhaps a required shared library or dll isn't installed where expected
at c:/razat/Perl/site/lib/Oraperl.pm line 55
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

Now if I uninstall the Oracle client, I am able to connect to the Oracle
server.
But I want to run both Oracle client and Perl DBI.
What should I do?

Please respond if you have any idea!

Regards,

Razat
-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@xxxxxxxxxxxxx]
Sent: Tuesday, October 18, 2005 2:23 AM
To: 'sreenivas reddy'; Gupta, Razat; dbi-users@xxxxxxxx
Subject: RE: Oracle/DBI

Put tnsnames.ora file and try

Regards
gsreddy

-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@xxxxxxxxxxxxx]
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@xxxxxxxx
Subject: RE: Oracle/DBI

Try to install DBD-Oracle module
Oracle database driver for the DBI module

Ppm>install DBD-Oracle

Regards
gsreddy

-----Original Message-----
From: Gupta, Razat [mailto:razat.gupta@xxxxxxxxxxxx]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@xxxxxxxx
Subject: Oracle/DBI

Hi Everyone,



I am trying to connect to an Oracle Database .

Previously, I was using perl DBI and DBD:;Orcacle for this purpose.

But now when I had installed an oracle client on my machine , I m
getting the following error while trying to access an Oracle Database
using my perl script.

When I had not installed the Oracle client , I was able to connect using
the same script.





ERROR:



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 n't be found at
c:/razat/Perl/lib/DynaLoader.pm line 230.



Perhaps a required shared library or dll isn't installed where expected

at c:/razat/Perl/site/lib/Oraperl.pm line 55

Compilation failed in require at -e line 1.

BEGIN failed--compilation aborted at -e line 1.



Razat Gupta

HCL TECHNOLOGIES

+91-9810674702















.



Relevant Pages

  • RE: Oracle/DBI
    ... Before installing Oracle client, I was able to connect to Oracle server. ... But I want to run both Oracle client and Perl DBI. ...
    (perl.dbi.users)
  • Re: MS02-018 Breaking ASP ODBC
    ... > after installing the latest security hotfixes as of April ... >>1) IIS 5 web server can't be contacted. ... >>before the patch and that fixed that problem. ... >>load some VB components that fail to connect to my Oracle ...
    (microsoft.public.inetserver.iis.security)
  • Re: was(can someone please explain what this blog tagging this is all about?), now, happy NY!
    ... Someone puts out a video of Oracle being "instantly" ... installing 10.2 base, then installing 10.2.0.3 on top of it ... meme propagation allows corrective feedback, ... In the traditional scientific community, ...
    (comp.databases.oracle.server)
  • was(can someone please explain what this blog tagging this is all about?), now, happy NY!
    ... Someone puts out a video of Oracle being "instantly" ... installing 10.2 base, then installing 10.2.0.3 on top of it ... While I'm here and on the subject of aggregators and ... next time I'm taking a shorter holiday! ...
    (comp.databases.oracle.server)
  • RE: Oracle/DBI
    ... Before installing Oracle client, I was able to connect to Oracle server. ... But I want to run both Oracle client and Perl DBI. ...
    (perl.dbi.users)