DBI problem
am 09.09.2005 20:49:56 von BVolf
------_=_NextPart_001_01C5B56F.46257AA6
Content-Type: text/plain
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.
------_=_NextPart_001_01C5B56F.46257AA6--
RE: DBI problem
am 09.09.2005 20:54:27 von Ron.Reidy
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Boris Volf [mailto:BVolf@bcgi.net]=20
Sent: Friday, September 09, 2005 12:50 PM
To: dbi-users@perl.org
Subject: DBI problem
Hi,
=20
=20
=20
I am trying to connect to an Oracle(8) database using DBI module.
=20
I have Perl 5.8.6 installed on my machine with DBI version 1.16, and DBD
version 1.47.
=20
Below is my program that I am using to connect to the Database
=20
use DBI;
=20
=20
=20
$db_handle =3D DBI->connect("dbi:Oracle:dbname", uname, pwd);
=20
$sql_errstr =3D $DBI::errstr;
=20
$sql_statement =3D $db_handle->prepare("select * from table");
=20
$sql_statement->execute;
=20
while(@row =3D $sql_statement->fetchrow_array)
=20
{print("$row[0]"); }
=20
$db_handle->disconnect;
=20
=20
This produces the following error:
=20
=20
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
=20
=20
=20
Can anyone help with this?
=20
Thanks,
=20
Boris
=20
-----------------------------------------
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=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.
RE: DBI problem
am 09.09.2005 21:02:51 von BVolf
------_=_NextPart_001_01C5B571.13C0CD2C
Content-Type: text/plain
Yes,
DBI version 1.48
DBD version 1.16
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
Sent: Friday, September 09, 2005 2:54 PM
To: Boris Volf; dbi-users@perl.org
Subject: RE: DBI problem
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Boris Volf [mailto:BVolf@bcgi.net]
Sent: Friday, September 09, 2005 12:50 PM
To: dbi-users@perl.org
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.
------_=_NextPart_001_01C5B571.13C0CD2C--
Re: DBI problem
am 11.09.2005 16:01:50 von jonathan.leffler
------=_Part_1169_9601186.1126447310156
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Dear Boris,
Please note that it is DBD::Oracle version 1.16 -- there is no generic=20
module DBD.
What Ron meant is "Have you ensured that you have installed DBD::Oracle and=
=20
all its pre-requisites?".
Given the error message you are seeing, I strongly suspect you have=20
installed DBD::Oracle itself, but DBD::Oracle (and, specifically, the=20
Oracle.dll generated for DBD::Oracle) needs the Oracle client libraries, an=
d=20
you havenot installed those on your Windows machine (it is often helpful to=
=20
mention the platform - for example, given that it is Windows, you probably=
=20
are using an ActiveState build of Perl, rather than one you did, and you=20
probably downloaded DBD::Oracle as well, rather than building it yourself;=
=20
if you'd built it yourself, you couldn't have done so without the Oracle=20
software, but you probably can install it without the Oracle software when=
=20
you download the PPM).
On 9/9/05, Boris Volf wrote:
>=20
> Yes,
> DBI version 1.48
> DBD version 1.16
>=20
> -----Original Message-----
> From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
> Sent: Friday, September 09, 2005 2:54 PM
> To: Boris Volf; dbi-users@perl.org
> Subject: RE: DBI problem
>=20
> Did you install DBD::Oracle?
>=20
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>=20
> -----Original Message-----
> From: Boris Volf [mailto:BVolf@bcgi.net]
> Sent: Friday, September 09, 2005 12:50 PM
> To: dbi-users@perl.org
> Subject: DBI problem
>=20
>=20
> Hi,
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> I am trying to connect to an Oracle(8) database using DBI module.
>=20
>=20
>=20
> I have Perl 5.8.6 installed on my machine with DBI version 1.16, and DBD
>=20
> version 1.47.
>=20
>=20
>=20
> Below is my program that I am using to connect to the Database
>=20
>=20
>=20
> use DBI;
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> $db_handle =3D DBI->connect("dbi:Oracle:dbname", uname, pwd);
>=20
>=20
>=20
> $sql_errstr =3D $DBI::errstr;
>=20
>=20
>=20
> $sql_statement =3D $db_handle->prepare("select * from table");
>=20
>=20
>=20
> $sql_statement->execute;
>=20
>=20
>=20
> while(@row =3D $sql_statement->fetchrow_array)
>=20
>=20
>=20
> {print("$row[0]"); }
>=20
>=20
>=20
> $db_handle->disconnect;
>=20
>=20
>=20
>=20
>=20
> This produces the following error:
>=20
>=20
>=20
>=20
>=20
> Install_driver(Oracle) failed: Can't load
>=20
> 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll for module DBD::Oracle:
>=20
> load_file:The specified procedure could not be found at
>=20
> C:/Perl/lib/Dynaloader.pm line230
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> Can anyone help with this?
>=20
>=20
>=20
> Thanks,
>=20
>=20
>=20
> Boris
>=20
>=20
>=20
>=20
>=20
>=20
> -----------------------------------------
> 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.
>=20
> 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=
=20
> 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.
>=20
>=20
--=20
Jonathan Leffler #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
------=_Part_1169_9601186.1126447310156--
RE: DBI problem
am 12.09.2005 16:05:24 von BVolf
------_=_NextPart_001_01C5B7A3.0BE8652F
Content-Type: text/plain
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@gmail.com]
Sent: Sunday, September 11, 2005 10:02 AM
To: Boris Volf
Cc: dbi-users@perl.org
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 > wrote:
Yes,
DBI version 1.48
DBD version 1.16
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com
]
Sent: Friday, September 09, 2005 2:54 PM
To: Boris Volf; dbi-users@perl.org
Subject: RE: DBI problem
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Boris Volf [mailto:BVolf@bcgi.net ]
Sent: Friday, September 09, 2005 12:50 PM
To: dbi-users@perl.org
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
> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
------_=_NextPart_001_01C5B7A3.0BE8652F--