perlnewb123 has asked for the wisdom of the Perl Monks concerning the following question:

Monks, im attempting to install mod DBD db2 on windows for activestate perl 5.10.0. Downloaded and installed from PPM. Got the following:
DBD-DB2 marked for install Installing package ... Downloading DBD-DB2-1.7.1 ... done Unpacking DBD-DB2-1.7.1 ... done Updating files in site area ... done Installing package done

Using DB2 Client installed to my machine, prior to attempting to run the module install, I have set my DB2_HOME variable

When I attempt to run my script I get this:
C:\>db2.pl Can't locate DBD/DB2.pm in @INC (@INC contains: C:/Perl/site/lib C:/Pe +rl/lib .) at C:\db2.pl line 5. BEGIN failed--compilation aborted at C:\db2.pl line 5.
Searching my install I cant find db2.pm... should ppm have installed this? Trying to install the mod through dmake I get all of this junk... Please help...

C:\DBD-DB2-1.71\DBD-DB2-1.71>perl Makefile.pl Set up gcc environment - 3.4.5 (mingw-vista special r3) Configuring DBD::DB2... Remember to actually read the README and CAVEATS files! Using DB2 in "C:/Program Files/IBM/SQLLIB" System: perl5.010000 DBI1.607 MSWin32-x86-multi-thread dl_win32.xs Compiler: gcc -O2 -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -DHASATTRIBUTE -fn o-strict-aliasing -mms-bitfields Includes: -I"C:/Program Files/IBM/SQLLIB/include" -I"C:\Perl\lib/auto/DBI" Libraries: -L"C:/Program Files/IBM/SQLLIB/lib" db2cli.lib db2api.lib -L"C:/Program Files/SQLXML 4.0/bin/" -L"C:/strawberry/c/lib" -L"C:/strawberry/perl/bin" Note (probably harmless): No library found for db2cli.lib Note (probably harmless): No library found for db2api.lib Writing Makefile for DBD::DB2::Constants Writing Makefile for DBD::DB2 C:\DBD-DB2-1.71\DBD-DB2-1.71> C:\DBD-DB2-1.71\DBD-DB2-1.71>dmake gcc -c -I"C:/Program Files/IBM/SQLLIB/include" -I"C:\Perl\lib/auto/DBI" -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX - DHASATTRIBUTE -fno-strict-aliasing -mms-bitfields -O2 -DVERSION=\"1.71\" -DXS_VERSION=\"1.71\" "-IC:\Perl\lib\CORE" -DDB2_CACHE_FIX DB2.c In file included from DB2.xs:7: DB2.h:11:20: sqlcli.h: No such file or directory DB2.h:13:21: sqlcli1.h: No such file or directory In file included from C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:13, from C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:7, from DB2.h:14, from DB2.xs:7: C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:17: error: syntax error before "UDWORD" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:18: error: syntax error before "UWORD" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:24: error: syntax error before "PTR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:25: error: syntax error before "HENV" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:26: error: syntax error before "HDBC" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:27: error: syntax error before "HSTMT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:29: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:34: error: syntax error before "SQLUINTEGER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:36: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:37: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:50: error: syntax error before "SQLHWND" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:51: error: syntax error before "BOOKMARK" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:71: error: syntax error before "SQLTCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:84: error: syntax error before "SQLBIGINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:85: error: syntax error before "SQLUBIGINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:90: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:94: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:96: error: syntax error before "second" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:100: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:102: error: syntax error before "hour" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:103: error: syntax error before "minute" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:104: error: syntax error before "second" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:105: error: syntax error before "fraction" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:108: error: syntax error before "SQL_DATE_STRUCT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:109: error: syntax error before "SQL_TIME_STRUCT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:110: error: syntax error before "SQL_TIMESTAMP_STRUCT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:118: error: syntax error before "SQLUINTEGER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:122: error: syntax error before "SQLUINTEGER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:124: error: syntax error before "minute" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:125: error: syntax error before "second" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:126: error: syntax error before "fraction" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:132: error: syntax error before "SQL_YEAR_MONTH_STRUCT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:135: error: syntax error before '}' token C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:138: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:140: error: syntax error before "sign" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:141: error: syntax error before "val" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:142: error: syntax error before '}' token C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:154: error: syntax error before "DWORD" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:156: error: syntax error before "Data3" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:157: error: syntax error before "Data4" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:158: error: syntax error before '}' token In file included from C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:7, from DB2.h:14, from DB2.xs:7: C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:346: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:348: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:349: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:351: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:352: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:357: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:358: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:360: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:362: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:363: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:364: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:365: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:366: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:367: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:368: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:369: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:370: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:372: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:373: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:374: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:375: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:376: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:377: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:378: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:379: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:382: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:384: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:389: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:390: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:391: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:393: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:394: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:395: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:396: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:397: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:398: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:400: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:401: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sql.h:402: error: syntax error before "SQLPOINTER" In file included from DB2.h:14, from DB2.xs:7: C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1184: error: syntax error before "SQLHWND" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1185: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1186: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1187: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1188: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1189: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1190: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1192: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1194: error: syntax error before "SQLUINTEGER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1195: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1196: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1197: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1198: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1199: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1200: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1201: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1202: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1203: error: syntax error before "ODBCGetTryWaitValue" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1204: error: syntax error before "ODBCSetTryWaitValue" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1207: error: syntax error before "TraceReturn" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1208: error: syntax error before "TraceVersion" In file included from C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1214, from DB2.h:14, from DB2.xs:7: C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:22: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:24: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:25: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:26: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:27: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:28: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:30: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:32: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:34: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:35: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:36: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:37: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:38: error: syntax error before "SQLHWND" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:39: error: syntax error before "SQLHWND" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:40: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:41: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:42: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:44: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:46: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:48: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:49: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:50: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:51: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:52: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:54: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:55: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:58: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:60: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:62: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:64: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:66: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:68: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:69: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:70: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:71: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:72: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:74: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:75: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:76: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:77: error: syntax error before "SQLUSMALLINT" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:78: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:80: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:83: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:84: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:85: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:86: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:87: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:89: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:90: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:91: error: syntax error before "SQLCHAR" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:93: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:94: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:95: error: syntax error before "SQLPOINTER" C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlucode.h:96: error: syntax error before "SQLPOINTER" DB2.h:16:66: sqlstate.h: No such file or directory In file included from C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/windows.h:48, from C:/Perl/lib/CORE/win32.h:61, from C:/Perl/lib/CORE/win32thread.h:4, from C:/Perl/lib/CORE/perl.h:2748, from C:/Perl/lib/auto/DBI/DBIXS.h:19, from DB2.h:18, from DB2.xs:7: C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/windef.h:229: error: 'DWORD' redeclared as different kind of symbol C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1208: error: previous declaration of 'DWORD' was here C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/windef.h:234: error: 'BOOL' redeclared as different kind of symbol C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqlext.h:1204: error: previous declaration of 'BOOL' was here In file included from DB2.h:22, from DB2.xs:7: dbdimp.h:56: error: syntax error before "SQLCHAR" dbdimp.h:56: warning: no semicolon at end of struct or union dbdimp.h:62: error: syntax error before '*' token dbdimp.h:62: warning: data definition has no type or storage class dbdimp.h:73: error: syntax error before '}' token dbdimp.h:82: error: syntax error before "SQLCHAR" dbdimp.h:82: warning: no semicolon at end of struct or union dbdimp.h:85: error: syntax error before "prec" dbdimp.h:85: warning: data definition has no type or storage class dbdimp.h:86: error: conflicting types for 'scale' C:/MinGW/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sqltypes.h:139: error: previous declaration of 'scale' was here dbdimp.h:95: error: syntax error before '}' token dbdimp.h:103: error: syntax error before "SQLUSMALLINT" dbdimp.h:103: warning: no semicolon at end of struct or union dbdimp.h:104: error: conflicting types for 'indp' dbdimp.h:91: error: previous declaration of 'indp' was here dbdimp.h:109: error: syntax error before "descColumnSize" dbdimp.h:109: warning: data definition has no type or storage class DB2.xs: In function `XS_DBD__DB2__st_execute': DB2.xs:355: error: dereferencing pointer to incomplete type DB2.xs:357: error: dereferencing pointer to incomplete type DB2.xs:362: error: dereferencing pointer to incomplete type DB2.xs:363: error: dereferencing pointer to incomplete type DB2.xs:364: error: dereferencing pointer to incomplete type DB2.xs:379: error: dereferencing pointer to incomplete type DB2.xs:380: error: dereferencing pointer to incomplete type DB2.xs: In function `XS_DBD__DB2__st_finish': DB2.xs:434: error: dereferencing pointer to incomplete type DB2.xs:435: error: dereferencing pointer to incomplete type DB2.xs:442: error: dereferencing pointer to incomplete type DB2.xs:442: error: dereferencing pointer to incomplete type DB2.xs:442: error: dereferencing pointer to incomplete type DB2.xs: In function `XS_DBD__DB2__st_DESTROY': DB2.xs:500: error: dereferencing pointer to incomplete type DB2.xs:502: error: dereferencing pointer to incomplete type DB2.xs:508: error: dereferencing pointer to incomplete type DB2.xs:509: error: dereferencing pointer to incomplete type DB2.xs:509: error: dereferencing pointer to incomplete type DB2.xs:509: error: dereferencing pointer to incomplete type DB2.xs:511: error: dereferencing pointer to incomplete type DB2.xs:512: error: dereferencing pointer to incomplete type DB2.xs:517: error: dereferencing pointer to incomplete type DB2.xs:517: error: dereferencing pointer to incomplete type DB2.xs:517: error: dereferencing pointer to incomplete type DB2.xs: In function `boot_DBD__DB2': DB2.xs:36: error: invalid application of `sizeof' to incomplete type `C:/Perl/lib/auto/DBI/DBIXS.h' dmake.exe: Error code 1, while making 'DB2.o'

Replies are listed 'Best First'.
Re: Need help installing Mod DBD/DB2 on windows
by Anonymous Monk on Apr 03, 2009 at 06:44 UTC
    Searching my install I cant find db2.pm... should ppm have installed this?
    Yes, it should have. What does the log say?
    Note (probably harmless): No library found for db2cli.lib Note (probably harmless): No library found for db2api.lib DB2.h:11:20: sqlcli.h: No such file or directory DB2.h:13:21: sqlcli1.h: No such file or directory
    Those are critical errors, it means you haven't installed DB2 Application Development Client v7.2 or later
Re: Need help installing Mod DBD/DB2 on windows
by AnomalousMonk (Archbishop) on Apr 03, 2009 at 07:36 UTC
Re: Need help installing Mod DBD/DB2 on windows
by andreas1234567 (Vicar) on Apr 03, 2009 at 06:49 UTC
    I installed DBD::DB2 on a WinXP machine. It does not have DB2 (client nor server) installed, so it should not work. The install appears successful, but ppm files DBD-DB2 lists no files, so I don't think it is:
    C:\>ppm install DBD-DB2 Downloading ActiveState Package Repository packlist...not modified Downloading DBD-DB2-1.7.1...done Unpacking DBD-DB2-1.7.1...done Updating files in site area...done C:\>ppm files DBD-DB2 C:\> C:\>perl -we "use DBD::DB2" Can't locate DBD/DB2.pm in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .) at -e line 1. BEGIN failed--compilation aborted at -e line 1.
    What does ppm files DBD-DB2 output on your system?
    --
    No matter how great and destructive your problems may seem now, remember, you've probably only seen the tip of them. [1]
      I found the problem, its a bug with the tarball on the repository, the directory inside is called DBD-DB2-1.71 instead of blib
      http://theoryx5.uwinnipeg.ca/ppms/DBD-DB2.ppd
      http://theoryx5.uwinnipeg.ca/ppms/x86/DBD-DB2.tar.gz
      Create DBD-DB2.ppd
      <SOFTPKG NAME="DBD-DB2" VERSION="1,7,1,0"> <TITLE>DBD-DB2</TITLE> <ABSTRACT>Perl driver for IBM DB2 Universal Database</ABSTRACT> <AUTHOR>DB2 Perl (db2perl@ca.ibm.com)</AUTHOR> <IMPLEMENTATION> <OS NAME="MSWin32" /> <ARCHITECTURE NAME="MSWin32-x86-multi-thread-5.8" /> <CODEBASE HREF="DBD-DB2.tar.gz" /> </IMPLEMENTATION> </SOFTPKG>
      download and fix tarball
      wget -c http://theoryx5.uwinnipeg.ca/ppms/x86/DBD-DB2.tar.gz ptar -zxvf DBD-DB2.tar.gz del DBD-DB2.tar.gz rename DBD-DB2-1.71 blib ptar -zcvf DBD-DB2.tar.gz blib rmdir /S /Q blib ppm install DBD-DB2.ppd
        Thanks for spotting this - I've fixed it now in our repository.