Posted on 2007-09-17 15:33:44-07 by gwampach
Problems installing the DBD-ODBC module
Hello,
I need to install the DBD-ODBC module. But I have problems.
I'm running Windows XP with the ActiveState port of Perl.
First I try to run the perl script using "perl Makefile.PL" but I get this:
C:\Perl\lib\DBD-ODBC-1.14>perl Makefile.PL You are using a Perl configured with threading enabled. Please read the warnings in DBI about this. You should also be aware that on non-Windows platforms ODBC drivers come in two forms, thread-safe and non-thread-safe drivers and you may need to make sure you are using the right one. Press return to continue... Configuring DBD::ODBC ... Remember to actually *READ* the README file! And re-read it if you have any problems. *** You're using Microsoft Visual C++ compiler or similar but the LIB and INCLUDE environment variables are not both set. You need to run the VCVARS32.BAT batch file that was supplied with the compiler before you can use it. A copy of vcvars32.bat can typically be found in the following directories under your Visual Studio install directory: Visual C++ 6.0: vc98\bin Visual Studio .NET: vc7\bin Find it, run it, then retry this. If you think this error is not correct then just set the LIB and INCLUDE environment variables to some value to disable the check.

I don't have either Visual C++ 6.0 nor Visual Studio .NET, I have Borland Developper Studio 2006.
So I set the 2 environment variables LIB and INCLUDE to arbitrary path and I get this message:
C:\Perl\lib\DBD-ODBC-1.14>perl Makefile.PL You are using a Perl configured with threading enabled. Please read the warnings in DBI about this. You should also be aware that on non-Windows platforms ODBC drivers come in two forms, thread-safe and non-thread-safe drivers and you may need to make sure you are using the right one. Press return to continue... Configuring DBD::ODBC ... Remember to actually *READ* the README file! And re-read it if you have any problems. Using DBI 1.58 (for perl 5.008008 on MSWin32-x86-multi-thread) installed in C:/P erl/lib/auto/DBI/ Note (probably harmless): No library found for ODBC32.LIB Note (probably harmless): No library found for oldnames.lib Note (probably harmless): No library found for kernel32.lib Note (probably harmless): No library found for user32.lib Note (probably harmless): No library found for gdi32.lib Note (probably harmless): No library found for winspool.lib Note (probably harmless): No library found for comdlg32.lib Note (probably harmless): No library found for advapi32.lib Note (probably harmless): No library found for shell32.lib Note (probably harmless): No library found for ole32.lib Note (probably harmless): No library found for oleaut32.lib Note (probably harmless): No library found for netapi32.lib Note (probably harmless): No library found for uuid.lib Note (probably harmless): No library found for ws2_32.lib Note (probably harmless): No library found for mpr.lib Note (probably harmless): No library found for winmm.lib Note (probably harmless): No library found for version.lib Note (probably harmless): No library found for odbc32.lib Note (probably harmless): No library found for odbccp32.lib Note (probably harmless): No library found for msvcrt.lib Using DBI 1.58 (for perl 5.008008 on MSWin32-x86-multi-thread) installed in C:/P erl/lib/auto/DBI/ Writing Makefile for DBD::ODBC The DBD::ODBC tests will use these values for the database connection: DBI_DSN=dbi:ODBC:filemaker_dsn e.g. dbi:ODBC:demo DBI_USER= DBI_PASS= Warning: not all required environment variables are set.

Next I try to run nmake from SDK 1.1 (remember I'm on windows) with this command: nmake and I get this error:
C:\Perl\lib\DBD-ODBC-1.14>nmake Microsoft (R) Program Maintenance Utility Version 7.10.3077 Copyright (C) Microsoft Corporation. All rights reserved. C:\Perl\bin\perl.exe -MExtUtils::Command -e cp Changes blib\lib\DBD\ODBC \Changes.pm cp ODBC.pm blib\lib\DBD\ODBC.pm cl -c -IC:\Perl\lib\auto\DBI -nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWI N32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO - DPERL_MSVCRT_READFIX -MD -Zi -DNDEBUG -O1 -DVERSION=\"1.14\" -DXS_VERSION=\" 1.14\" "-IC:\Perl\lib\CORE" -DWITH_UNICODE ConvertUTF.c 'cl' is not recognized as an internal or external command, operable program or batch file. NMAKE : fatal error U1077: 'cl' : return code '0x1'

Can anyone suggest how to get this module compiled and installed properly under windows, or tell me where I can find a pre-compiled version for windows XP?
Note: I will need to do the same thing for DBD-mysql...
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.