Hi ,
=20
how do i ensure that DBI is installed in my machine..
=20
will it be automatically installed when perl is installed...
=20
=20
i am getiing error when i start using use DBI;
=20
and i need to connet to ORACLE DATABASE.=20
=20
=20
please help me regding this issue..
=20
=20
=20
regds
R . Rajasekar
------_=_NextPart_001_01C684BC.AA050894
Content-Type: text/plain
Hello, R . Rajasekar
perl -e 'use DBI;'
I would ask what platform you are using that does not have perl installed?
Most unix platforms will already have a default installation of perl and
DBI. If you are installing on windows, you will likely use ActiveState; it
has been a while since I installed active state, but I seem to recall that
it installed DBI.
Oracle and the DBD driver are another story. DBD::Oracle will be required to
use DBI to connect to an Oracle database. No, this is not likely installed
on a default installation.
Perhaps you could post more information: platform, error message, connection
code...
Hope this helps,
Christian Werner
-----Original Message-----
Hi ,
how do i ensure that DBI is installed in my machine..
will it be automatically installed when perl is installed...
i am getiing error when i start using use DBI;
and i need to connet to ORACLE DATABASE.
please help me regding this issue..
regds
R . Rajasekar
------_=_NextPart_001_01C684BC.AA050894--
Chris Werner wrote:
> Hello, R . Rajasekar
>
> perl -e 'use DBI;'
>
> I would ask what platform you are using that does not have perl installed?
> Most unix platforms will already have a default installation of perl and
> DBI. If you are installing on windows, you will likely use ActiveState; it
> has been a while since I installed active state, but I seem to recall that
> it installed DBI.
DBI is not core. You have to install it from CPAN or via ppm on ActiveState.
David
--
Much of the propaganda that passes for news in our own society is given
to immobilising and pacifying people and diverting them from the idea
that they can confront power. -- John Pilger
Neither DBI nor DBD::Oracle are installed as part of the Perl distro.
To see if either module is installed:
$ perl -MDBI -e '0'
$ perl -MDBD::Oracle -e '0'
If you need to install either module, google will be your friend.
-----Original Message-----
From: R, Rajsekar [mailto:Rajasekar.R@ps.net]=20
Sent: Wednesday, May 31, 2006 7:46 AM
To: dbi-users@perl.org
Subject: perl- dbi
Hi ,
=20
how do i ensure that DBI is installed in my machine..
=20
will it be automatically installed when perl is installed...
=20
=20
i am getiing error when i start using use DBI;
=20
and i need to connet to ORACLE DATABASE.=20
=20
=20
please help me regding this issue..
=20
=20
=20
regds
R . Rajasekar
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.
On 5/31/06, R, Rajsekar
> how do i ensure that DBI is installed in my machine..
> will it be automatically installed when perl is installed...
>
> i am getiing error when i start using use DBI;
> and i need to connet to ORACLE DATABASE.
You've received a few workable answers - but there's a better one.
perl -MDBI -e 'print "$DBI::VERSION\n"'
This tells you which version of DBI you have installed - which can be
even more valuable than simply knowing that DBI is installed.
Similarly:
perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"'
Similarly for any other (civilized) module - whether in the DBI/DBD
collection or not.
--
Jonathan Leffler
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
-----Original Message-----
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]=20
Sent: Wednesday, May 31, 2006 12:02 PM
To: R, Rajsekar
Cc: dbi-users@perl.org
Subject: Re: perl- dbi
>=20
> On 5/31/06, R, Rajsekar
> > how do i ensure that DBI is installed in my machine..
> > will it be automatically installed when perl is installed...
> >
> > i am getiing error when i start using use DBI; and i need to connet
> > to ORACLE DATABASE.
>=20
> You've received a few workable answers - but there's a better one.
>=20
> perl -MDBI -e 'print "$DBI::VERSION\n"'
Or this:
perl -MDBI -e 'DBI->installed_versions'
which tells you what DBD modules are installed, and the versions of
pretty much anything that matters to DBI, as someone recently
pointed out to me.
E.g.:
$ perl -MDBI -e 'DBI->installed_versions'
Perl : 5.008003 (i586-linux-thread-multi)
OS : linux (2.6.5)
DBI : 1.50
DBD::Sponge : 11.10
DBD::SQLite : 1.11
DBD::SQLRelay : 0.37
DBD::Proxy : install_driver(Proxy) failed: Can't locate
RPC/PlClient.pm in @INC
DBD::Oracle : 1.17
DBD::File : 0.33
DBD::ExampleP : 11.12
DBD::DBM : 0.03
Philip
Jonathan Leffler wrote:
> You've received a few workable answers - but there's a better one.
>
> perl -MDBI -e 'print "$DBI::VERSION\n"'
>
> This tells you which version of DBI you have installed - which can be
> even more valuable than simply knowing that DBI is installed.
>
> Similarly:
>
> perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"'
And here's an even better one, assuming a relatively modern DBI:
perl -MDBI -e "DBI->installed_versions"
That tells you the versions of DBI, Perl, OS, and all DBDs installed.
--
Jeff
Hi,
=20
I am getting this error . please let me know.. what needs to be done =
further
=20
perl -MDBI -e 'print "$DBI::VERSION\n"'
Can't locate DBI.pm in @INC (@INC contains: =
/usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 =
/usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).
BEGIN failed--compilation aborted.
=20
=20
=20
Regds,
R.Rajasekar
________________________________
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Sent: Wed 31/05/2006 21:31
To: R, Rajsekar
Cc: dbi-users@perl.org
Subject: Re: perl- dbi
On 5/31/06, R, Rajsekar
> how do i ensure that DBI is installed in my machine..
> will it be automatically installed when perl is installed...
>
> i am getiing error when i start using use DBI;
> and i need to connet to ORACLE DATABASE.
You've received a few workable answers - but there's a better one.
perl -MDBI -e 'print "$DBI::VERSION\n"'
This tells you which version of DBI you have installed - which can be
even more valuable than simply knowing that DBI is installed.
Similarly:
perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERSION\n"'
Similarly for any other (civilized) module - whether in the DBI/DBD
collection or not.
--
Jonathan Leffler
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
On 6/1/06, R, Rajsekar
> I am getting this error . please let me know.. what needs to be done further
>
> perl -MDBI -e 'print "$DBI::VERSION\n"'
> Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).
> BEGIN failed--compilation aborted.
Download, compile and install DBI. And the driver for the DBMS you plan to use.
--
Jonathan Leffler
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
On 6/1/06, Jonathan Leffler
> On 6/1/06, R, Rajsekar
> > I am getting this error . please let me know.. what needs to be done further
> >
> > perl -MDBI -e 'print "$DBI::VERSION\n"'
> > Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .).
> > BEGIN failed--compilation aborted.
>
>
> Download, compile and install DBI. And the driver for the DBMS you plan to use.
And, since you're using a seriously down-version of Perl, you need to
get yourself a sufficiently *old* version of DBI - one that will work
with Perl 5.5.3; the current version requires 5.6.1.
You'd be best off getting Perl 5.8.8 and redoing all the modules.
It'll be harder in the short term, but you might not need to do it
again for another 3 years.
--
Jonathan Leffler
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
If one wanted to get up to date for a while on a Perl-DBI-Informix
combo, would this be a good set of versions:
Perl 5.8.8
DBI 1.50
DBD::Informix 2005.02
We're not changing Informix itself at this point. Just wanted to recap
versions for Perl and libraries based on what's been mentioned in this
list and what I've seen on CPAN. The OS is Sun.
-Will
> -----Original Message-----
> From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]=20
> Sent: Thursday 01 June 2006 10:58
> To: R, Rajsekar
> Cc: dbi-users@perl.org
> Subject: Re: perl- dbi
>=20
> And, since you're using a seriously down-version of Perl, you need to
> get yourself a sufficiently *old* version of DBI - one that will work
> with Perl 5.5.3; the current version requires 5.6.1.
>=20
> You'd be best off getting Perl 5.8.8 and redoing all the modules.
> It'll be harder in the short term, but you might not need to do it
> again for another 3 years.
>=20
- - - - - Appended by Scientific Atlanta, a Cisco company - - - - -=20
This e-mail and any attachments may contain information which is confidenti=
al, proprietary, privileged or otherwise protected by law. The information =
is solely intended for the named addressee (or a person responsible for del=
ivering it to the addressee). If you are not the intended recipient of this=
message, you are not authorized to read, print, retain, copy or disseminat=
e this message or any part of it. If you have received this e-mail in error=
, please notify the sender immediately by return e-mail and delete it from =
your computer.
On 6/5/06, Rutherdale, Will
> If one wanted to get up to date for a while on a Perl-DBI-Informix
> combo, would this be a good set of versions:
>
> Perl 5.8.8
> DBI 1.50
> DBD::Informix 2005.02
>
> We're not changing Informix itself at this point. Just wanted to recap
> versions for Perl and libraries based on what's been mentioned in this
> list and what I've seen on CPAN. The OS is Sun.
Those are all the most recent versions, though Tim is preparing a DBI
1.51 release.
That's what I have on my Solaris machine at the office.
--
Jonathan Leffler
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."