DBD-ODBC and DBI 1.21

I've been forced to upgrade a server to Activestate Perl 5.10 on Win2K
because of new module that does not appear to be available under
earlier versions.

A big complication is that the machine is behind a firewall, and PPM
cannot be used to install modules. I've had to download and install
about 30 modules by hand, and have resolved all issues except for this
one

This upgrade is requiring me to reload DBI and DBD-ODBC. The issue is
that the DBD-ODBC install fails because it requires DBI 1.21. Googling
everything I can find over the past couple of days indicates that this
is a popular problem. The problem is that I can't find an Activestate
compatible version of DBI 1.21, and can't get the CPAN version to
make.  I've looked in the Activestate folders of downloadable zips for
all Perl releases, and 1.21 does not exist. I've found:

5xx - 1.14
6xx - 1.34, 1.35, 1.37, 1.48
8xx - 1.35 - 1.602
10xx - 1.602

But no 1.21.  I attempted to download DBI 1.21 from CPAN and build it
using NMAKE fails with the following error:

E:\DEV\Docs\perl_mods_5.10\DBI_1.21\ungz\DBI-1.21>nmake

Microsoft (R) Program Maintenance Utility   Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

C:\Perl\bin\perl.exe -MExtUtils::Command -e cp Changes blib
\lib/DBI/Chan
ges.pm
cl -c    -nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWIN32 -
D_CONSOLE -DNO_ST
RICT -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -
DPERL_IMPLICIT
_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -
Zi -DNDEBUG
-O1    -DVERSION=\"1.21\"  -DXS_VERSION=\"1.21\"  "-IC:\Perl\lib
\CORE"   Perl.c

'cl' is not recognized as an internal or external command,
operable program or batch file.
NMAKE : fatal error U1077: 'C:\WINNT\system32\cmd.exe' : return code
'0x1'
Stop.


What to do now?  Or am I just doing something stupid?

Hi J

> 'cl' is not recognized as an internal or external command,
> operable program or batch file.

This means you don't have the MS compiler in your PATH. Do you have in
installed at all?

If not, you or someone else will have to compile the module on a
different machine, or you'll have to install it.
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

On Fri, 25 Apr 2008 07:48:35 -0700 (PDT), jbeadles wrote:

>This upgrade is requiring me to reload DBI and DBD-ODBC. The issue is
>that the DBD-ODBC install fails because it requires DBI 1.21. Googling
>everything I can find over the past couple of days indicates that this
>is a popular problem. The problem is that I can't find an Activestate
>compatible version of DBI 1.21, and can't get the CPAN version to
>make.  I've looked in the Activestate folders of downloadable zips for
>all Perl releases, and 1.21 does not exist. I've found:
>
>5xx - 1.14
>6xx - 1.34, 1.35, 1.37, 1.48
>8xx - 1.35 - 1.602
>10xx - 1.602
>
>But no 1.21.

Eh, what??

It requires *at least* version 1.21 of DBI. There's no need for it to be
exactly that version. You can install anything newer.

--
Bart.

On Apr 26, 3:19=A0am, bart.lat...@pandora.be (Bart Lateur) wrote:
> On Fri, 25 Apr 2008 07:48:35 -0700 (PDT), jbeadles wrote: 
> 
> 
>
> Eh, what??
>
> It requires *at least* version 1.21 of DBI. There's no need for it to be
> exactly that version. You can install anything newer.
>
> --
> =A0 =A0 =A0 =A0 Bart.

As I've been trying to resolve all these module conflicts, I noticed
something.  When I do a manual "ppm install" of a ppd, ppm does not
take into account modules in the default install when resolving
dependencies.  Therefore, even though 5.10 comes with DBI 1.601, PPM
doesn't see it when installing DBD-ODBC.  Hm.

On Apr 28, 12:59=A0pm, jbead...@pobox.com (Jbeadles) wrote:
> On Apr 26, 3:19=A0am, bart.lat...@pandora.be (Bart Lateur) wrote:
>
>
>
>
> 
r 
> 
> 
> 
> 
 
> 
>
> As I've been trying to resolve all these module conflicts, I noticed
> something. =A0When I do a manual "ppm install" of a ppd, ppm does not
> take into account modules in the default install when resolving
> dependencies. =A0Therefore, even though 5.10 comes with DBI 1.601, PPM
> doesn't see it when installing DBD-ODBC. =A0Hm.- Hide quoted text -
>
> - Show quoted text -

After figuring this out, I did a ppm install dbd-odbc.ppd - nodeps.
This worked, and I'm successfully querying the database.