RE: DBI problem
- From: BVolf@xxxxxxxx (Boris Volf)
- Date: Mon, 12 Sep 2005 10:05:24 -0400
So what do I need to do?
I ran thru everything this morning again on a different machine.
I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from
ActiveState Perl 5.8.6.
When I had 5.8.6 everything was working fine, so I uninstalled Perl
completely and installed 5.8.6 version back again. Using PPM, I downloaded
DBD 1.16 and DBI 1.48.
And got this error again
Let me know if you can help,
Thanks,
Boris
_____
From: Jonathan Leffler [mailto:jonathan.leffler@xxxxxxxxx]
Sent: Sunday, September 11, 2005 10:02 AM
To: Boris Volf
Cc: dbi-users@xxxxxxxx
Subject: Re: DBI problem
Dear Boris,
Please note that it is DBD::Oracle version 1.16 -- there is no generic
module DBD.
What Ron meant is "Have you ensured that you have installed DBD::Oracle and
all its pre-requisites?".
Given the error message you are seeing, I strongly suspect you have
installed DBD::Oracle itself, but DBD::Oracle (and, specifically, the
Oracle.dll generated for DBD::Oracle) needs the Oracle client libraries, and
you havenot installed those on your Windows machine (it is often helpful to
mention the platform - for example, given that it is Windows, you probably
are using an ActiveState build of Perl, rather than one you did, and you
probably downloaded DBD::Oracle as well, rather than building it yourself;
if you'd built it yourself, you couldn't have done so without the Oracle
software, but you probably can install it without the Oracle software when
you download the PPM).
On 9/9/05, Boris Volf <BVolf@xxxxxxxx <mailto:BVolf@xxxxxxxx> > wrote:
Yes,
DBI version 1.48
DBD version 1.16
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx
<mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx> ]
Sent: Friday, September 09, 2005 2:54 PM
To: Boris Volf; dbi-users@xxxxxxxx <mailto:dbi-users@xxxxxxxx>
Subject: RE: DBI problem
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Boris Volf [mailto:BVolf@xxxxxxxx <mailto:BVolf@xxxxxxxx> ]
Sent: Friday, September 09, 2005 12:50 PM
To: dbi-users@xxxxxxxx <mailto:dbi-users@xxxxxxxx>
Subject: DBI problem
Hi,
I am trying to connect to an Oracle(8) database using DBI module.
I have Perl 5.8.6 installed on my machine with DBI version 1.16, and DBD
version 1.47.
Below is my program that I am using to connect to the Database
use DBI;
$db_handle = DBI->connect("dbi:Oracle:dbname", uname, pwd);
$sql_errstr = $DBI::errstr;
$sql_statement = $db_handle->prepare("select * from table");
$sql_statement->execute;
while(@row = $sql_statement->fetchrow_array)
{print("$row[0]"); }
$db_handle->disconnect;
This produces the following error:
Install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll for module DBD::Oracle:
load_file:The specified procedure could not be found at
C:/Perl/lib/Dynaloader.pm line230
Can anyone help with this?
Thanks,
Boris
-----------------------------------------
The information contained in this e-mail message and any attachments is
confidential, and is intended only for the use of the party to whom it
is addressed. If you are not the above-named intended recipient, you
are hereby notified that any dissemination, copying or disclosure of
this communication is strictly prohibited. If you have received this
communication in error, please notify Boston Communications Group, Inc.
immediately by reply to this message or by telephoning (781) 904-5000,
and destroy this message and its attachments, without making any copy or
distribution.
This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not
the
intended recipient, please be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
Jonathan Leffler <jonathan.leffler@xxxxxxxxx
<mailto:jonathan.leffler@xxxxxxxxx> > #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
<http://dbi.perl.org>
"I don't suffer from insanity - I enjoy every minute of it."
- Prev by Date: Re: Lost connection error with prepare_cached
- Next by Date: DBI::Pg
- Previous by thread: Re: DBI problem
- Next by thread: Re: ANNOUNCE:: DBIx::MyParse 0.20
- Index(es):
Relevant Pages
|
