Oracle/DBI

Oracle/DBI

am 18.10.2005 09:06:43 von razat.gupta

------_=_NextPart_001_01C5D3B2.8338E491
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi Everyone,

=20

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.

=20

=20

ERROR:

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

=20

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.

=20

Razat Gupta

HCL TECHNOLOGIES

+91-9810674702=20

=20

=20


------_=_NextPart_001_01C5D3B2.8338E491--

RE: Oracle/DBI

am 18.10.2005 09:20:23 von sreenivas.gilella

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@spansion.com]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
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

RE: Oracle/DBI

am 18.10.2005 09:23:20 von sreenivas.gilella

Put tnsnames.ora file and try

Regards
gsreddy

-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@valuelabs.net]
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@perl.org
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@spansion.com]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
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

RE: Oracle/DBI

am 18.10.2005 10:50:01 von razat.gupta

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@valuelabs.net]=20
Sent: Tuesday, October 18, 2005 2:23 AM
To: 'sreenivas reddy'; Gupta, Razat; dbi-users@perl.org
Subject: RE: Oracle/DBI

Put tnsnames.ora file and try

Regards
gsreddy

-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@valuelabs.net]=20
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@perl.org
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@spansion.com]=20
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
Subject: Oracle/DBI

Hi Everyone,

=20

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.

=20

=20

ERROR:

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

=20

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.

=20

Razat Gupta

HCL TECHNOLOGIES

+91-9810674702=20

=20

=20

RE: Oracle/DBI

am 18.10.2005 11:07:02 von stbaldwin

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@spansion.com]
Sent: Tuesday, 18 October 2005 6:50 PM
To: sreenivas reddy
Cc: dbi-users@perl.org
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@valuelabs.net]
Sent: Tuesday, October 18, 2005 2:23 AM
To: 'sreenivas reddy'; Gupta, Razat; dbi-users@perl.org
Subject: RE: Oracle/DBI

Put tnsnames.ora file and try

Regards
gsreddy

-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@valuelabs.net]
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@perl.org
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@spansion.com]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
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

RE: Oracle/DBI

am 18.10.2005 22:21:55 von stbaldwin

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@spansion.com]
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@multiservice.com]
Sent: Tuesday, October 18, 2005 4:07 AM
To: dbi-users@perl.org
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@spansion.com]
Sent: Tuesday, 18 October 2005 6:50 PM
To: sreenivas reddy
Cc: dbi-users@perl.org
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@valuelabs.net]
Sent: Tuesday, October 18, 2005 2:23 AM
To: 'sreenivas reddy'; Gupta, Razat; dbi-users@perl.org
Subject: RE: Oracle/DBI

Put tnsnames.ora file and try

Regards
gsreddy

-----Original Message-----
From: sreenivas reddy [mailto:sreenivas.gilella@valuelabs.net]
Sent: Tuesday, October 18, 2005 12:50 PM
To: 'Gupta, Razat'; dbi-users@perl.org
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@spansion.com]
Sent: Tuesday, October 18, 2005 12:37 PM
To: dbi-users@perl.org
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