Help Required:Installing DBI in Perl 5.005

------=_Part_95168_33256109.1169124637551
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear Friends,
I am not having much experience in Perl except from
programming.
I have Perl 5.005 in Unix environment.I have no issues with running any PErl
Script.
But I cant access my Oracle Database(92) through Perl Script.
Its throwing error
*Can't locate object method "connect" via package "DBI"*

*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 .) at PerlDatabaseConnection.pl line 10.*
Please let me know which version of DBI shud I install and where can I get
this.
If we dont have Perl5.005 compatible DBI in market; then what is the other
alternative...

I also have posted the same in
http://www.cpanforum.com/posts/4081

Regards
Naim


Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 '
hint=previous, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-xO3 -xdepend', gccversion=
cppflags=''
ccflags =''
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
/usr/perl5/5.00503/sun4-solaris/CORE'
cccdlflags='-KPIC', lddlflags='-G'


Characteristics of this binary (from libperl):
Built under solaris
Compiled at Dec 22 1999 00:00:57
@INC:
/usr/perl5/5.00503/sun4-solaris
/usr/perl5/5.00503
/usr/perl5/site_perl/5.005/sun4-solaris
/usr/perl5/site_perl/5.005

------=_Part_95168_33256109.1169124637551--

Re: Help Required:Installing DBI in Perl 5.005

------=_Part_114497_29664694.1169130249722
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Why don't you do the sensible thing and upgrade to Perl 5.8.8?

Presumably, you have a reason that seems sensible to you - though if you've
not considered the option, you should do it, and do it now (where 'do'
encompasses both 'think about installing Perl 5.8.8' and 'actually install
Perl 5.8.8').

Assuming you can't upgrade (what was the reason again? you're kidding - you
could upgrade!) you'll probably need to dig through the release notes for
DBI to find the last version that supports Perl 5.5, and then obtain that
source manually from the CPAN archive (not by trying to use CPAN or CPANPLUS
modules). Then you'll need to obtain a compatible version of DBD::Oracle,
and install that.

You can find DBI modules back to 1.13 at

http://www.cpan.org/modules/by-authors/id/TIMB/

The Oracle versions only go back to 1.14 - and may not cover the latest ones
either; you can hunt those down yourself.

On 1/18/07, Mohd Naim wrote:
>
> Dear Friends,
> I am not having much experience in Perl except from
> programming.
> I have Perl 5.005 in Unix environment.I have no issues with running any
> PErl
> Script.
> But I cant access my Oracle Database(92) through Perl Script.
> Its throwing error
> *Can't locate object method "connect" via package "DBI"*
>
> *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 .) at PerlDatabaseConnection.pl line 10.*
> Please let me know which version of DBI shud I install and where can I get
> this.
> If we dont have Perl5.005 compatible DBI in market; then what is the other
> alternative...
>
> I also have posted the same in
> http://www.cpanforum.com/posts/4081
>
> Regards
> Naim
>
>
> Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
> Platform:
> osname=solaris, osvers=2.8, archname=sun4-solaris
> uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 '
> hint=previous, useposix=true, d_sigaction=define
> usethreads=undef useperlio=undef d_sfio=undef
> Compiler:
> cc='cc', optimize='-xO3 -xdepend', gccversion=
> cppflags=''
> ccflags =''
> stdchar='char', d_stdstdio=define, usevfork=false
> intsize=4, longsize=4, ptrsize=4, doublesize=8
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
> alignbytes=8, usemymalloc=n, prototype=define
> Linker and Libraries:
> ld='cc', ldflags =''
> libpth=/lib /usr/lib /usr/ccs/lib
> libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
> libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
> /usr/perl5/5.00503/sun4-solaris/CORE'
> cccdlflags='-KPIC', lddlflags='-G'
>
>
> Characteristics of this binary (from libperl):
> Built under solaris
> Compiled at Dec 22 1999 00:00:57
> @INC:
> /usr/perl5/5.00503/sun4-solaris
> /usr/perl5/5.00503
> /usr/perl5/site_perl/5.005/sun4-solaris
> /usr/perl5/site_perl/5.005
>
>


--
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_114497_29664694.1169130249722--

Re: Help Required:Installing DBI in Perl 5.005

--YhFoJY/gx7awiIuK
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2007-01-18 06:24:09 -0800, Jonathan Leffler wrote:
> On 1/18/07, Mohd Naim wrote:
> >I have Perl 5.005 in Unix environment.I have no issues with running
> >any PErl Script.
> >But I cant access my Oracle Database(92) through Perl Script.

> Why don't you do the sensible thing and upgrade to Perl 5.8.8?

While I agree that this is probably a lot more sensible than trying to
get a seriously outdated perl installation to play nicely with a
reasonably current Oracle installation, that may not actually be the
issue in this case:


> >Its throwing error
> >*Can't locate object method "connect" via package "DBI"*
> >
> >*Can't locate dbi.pm in @INC (@INC contains:
^^^
Note that perl is looking for "dbi.pm", not "DBI.pm" here. Looks like
the OP wrote "use dbi" instead of "use DBI".


[...]

> You can find DBI modules back to 1.13 at
>=20
> http://www.cpan.org/modules/by-authors/id/TIMB/
>=20
> The Oracle versions only go back to 1.14 - and may not cover the latest o=
nes
> either; you can hunt those down yourself.

You can find even older versions on BackPAN:

http://backpan.cpan.org/authors/Tim_Bunce/

starts with DBI-0.89 and DBD-Oracle-0.47 from 1997.

hp

--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--YhFoJY/gx7awiIuK
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQDQAwUBRa+ZFVLjemazOuKpAQKbpAXSAzhSWZdikfuApiwezPWwhszmxn7j AgNM
eTAUAAbprQvJoBj6qGnkwLZJx9znjoglyOg8iutKmZXWWBHHsrT7shu/tN3y co7I
HSObPm+KpwXUPyYoliTVLE83bF7jnx+HrTSlyPE48GKcKkTS8umnFPHFpg4g OVnp
WUaoEmSwRgNaimYJAw6EyMjwC2hE253qkZHwSfjawPvnwJiFuFeUXfzeKnqP 4cci
GvgexbyqFx4zNXGJQ1a5dGjE3Q==
=uHPc
-----END PGP SIGNATURE-----

--YhFoJY/gx7awiIuK--