Any help with these make errors would be greatly appreciated. I am stuck at the moment. I am hacking the install paths because I do not have permission to install into site_perl, but I have done this with other DBD drivers and DBI versions with success.

Want to install DBI/DBD on mSQL-2.03, perl5.004, IRIX 6.2, C/C++ 6.2. The first errors below are from mSQL-2.03, DBI-1.08 (LATEST), Msql-Mysql-modules-1.2016 (LATEST), but I also included some errors from mSQL-2.09 (LATEST), DBI-1.08, Msql-Mysql-modules-1.2016. Also, I have tried DBI-0.94, 1.00, 1.04-7 and Msql-Mysql-modules-1.2016 in various combinations with mSQL-2.03 and got fatal errors on all.

I do need to stick with mSQL-2.03 till about July 1. I can wait and try again then but wanted to start converting some existing apps to use DBI from use Msql at a more leisurely pace.

Thanks, Brad

mSQL-2.03, DBI-1.08, Msql-Mysql-modules-1.2017 MAKE OUTPUT ==========================================================

/work/mSQL/lib/dbd/Msql-Mysql-modules-1.2017/ 44> perl -I /d/occam/mSQL/lib/perl5.004/site_perl -I /d/occam/mSQL/lib/perl5.004 -I /d/occam/mSQL/lib/perl5.004/IP20-irix/5.00404 Makefile.PL

Checking for DBI, 0.93 or later ... ok Checking for Data::Dumper ... ok Checking for Data::ShowTable ... ok

Which DBMS do you want to use?

1) MySQL 2) mSQL (1 or 2) 3) Both MySQL and mSQL

4) mSQL1 and mSQL2 5) Everything (MySQL, mSQL1 and mSQL2)

Enter your choice: [3] 2

Do you want to install the MsqlPerl emulation? You might keep your old Msql module (to be distinguished from DBD::mSQL!) if you are concerned about compatibility to existing applications! [n] Which database should I use for testing the mSQL drivers? [test] On which host is database test running (hostname, ip address or host:port) [localhost] Where is your mSQL installed? Please tell me the directory that contains the subdir include/. [/usr/local/Hughes] Creating Msql files ..................... Checking if your kit is complete... Looks good Writing Makefile for DBD::mSQL Writing Makefile for Msql-Mysql-modules

/work/mSQL/lib/dbd/Msql-Mysql-modules-1.2017/ 46> make

mkdir ./blib mkdir ./blib/lib mkdir ./blib/arch mkdir ./blib/arch/auto mkdir ./blib/arch/auto/Msql-Mysql-modules mkdir ./blib/lib/auto mkdir ./blib/lib/auto/Msql-Mysql-modules mkdir ./blib/man1 mkdir .././blib/lib/DBD mkdir .././blib/arch/auto/DBD mkdir .././blib/arch/auto/DBD/mSQL mkdir .././blib/lib/auto/DBD mkdir .././blib/lib/auto/DBD/mSQL mkdir .././blib/man3 cp mSQL.pm .././blib/lib/DBD/mSQL.pm cc -c -I../dbd -I/usr/local/Hughes/include -I/usr/local/lib/perl5.004/site_perl/IP20-irix/auto/DBI -I/usr/l ocal/lib/perl5.004/IP20-irix/5.00404 -I/d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/auto/DBI -32 -D_BSD_TYPES -D_ BSD_TIME -Olimit 3100 -I/usr/local/include -DLANGUAGE_C -O -DVERSION=\"2.0217\" -DXS_VERSION=\"2.0217\" -KPIC - I/usr/local/lib/perl5.004/IP20-irix/5.00404/CORE -DDBD_MSQL -DMyConnect=mSQL_dr_connect -DMyLogin=mSQL_dr_login dbd imp.c cfe: Error: ../dbd/bindparam.h, line 199: 'SQL_BIGINT' undefined; reoccurrences will not be reported. case SQL_BIGINT: -----------^ cfe: Error: ../dbd/bindparam.h, line 205: 'SQL_DATE' undefined; reoccurrences will not be reported. case SQL_DATE: -----------^ cfe: Error: dbdimp.c, line 1334: 'SQL_DATE' undefined; reoccurrences will not be reported. case 7 : i = SQL_DATE; break; -----------------------^ cfe: Error: dbdimp.c, line 1335: 'SQL_BIGINT' undefined; reoccurrences will not be reported. case 8 : i = SQL_BIGINT; break; -----------------------^ cfe: Error: dbdimp.c, line 1337: 'SQL_TIME' undefined; reoccurrences will not be reported. case 10 : i = SQL_TIME; break; ------------------------^ *** Error code 1 (bu21) *** Error code 1 (bu21)

mSQL-2.09 (LATEST), DBI-1.08, Msql-Mysql-modules-1.2017 MAKE OUTPUT ===================================================================

/work/mSQL/lib/dbd/Msql-Mysql-modules-1.2017/ 105> make cc -c -I../dbd -I/usr/local/Hughes/include -I/usr/local/lib/perl5.004/site_perl/IP20-irix/auto/DBI -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/auto/DBI -32 -D_BSD_TYPES -D_BSD_TIME -Olimit 3100 -I/usr/local/include -DLANGUAGE_C -O -DVERSION=\"2.0217\" -DXS_VERSION=\"2.0217\" -KPIC -I/usr/local/lib/perl5.004/IP20-irix/5.00404/CORE -DDBD_MSQL -DMyConnect=mSQL_dr_connect -DMyLogin=mSQL_dr_login dbdimp.c cfe: Error: /usr/local/Hughes/include/common/portability.h, line 74: redeclaration of 'u_int'; previous declaration at line 34 in file '/usr/include/sys/bsd_types.h' typedef unsigned int u_int; ------- -------------^ cfe: Error: /usr/local/Hughes/include/common/portability.h, line 78: redeclaration of 'ssize_t'; previous declaration at line 183 in file '/usr/include/sys/types.h' typedef int ssize_t; ------------- ^ cfe: Error: ../dbd/bindparam.h, line 199: 'SQL_BIGINT' undefined; reoccurrences will not be reported. case SQL_BIGINT: -----------^ cfe: Error: ../dbd/bindparam.h, line 205: 'SQL_DATE' undefined; reoccurrences will not be reported. case SQL_DATE: -----------^ cfe: Error: dbdimp.c, line 1334: 'SQL_DATE' undefined; reoccurrences will not be reported. case 7 : i = SQL_DATE; break; -----------------------^ cfe: Error: dbdimp.c, line 1335: 'SQL_BIGINT' undefined; reoccurrences will not be reported. case 8 : i = SQL_BIGINT; break; -----------------------^ cfe: Error: dbdimp.c, line 1337: 'SQL_TIME' undefined; reoccurrences will not be reported. case 10 : i = SQL_TIME; break; ------------------------^ *** Error code 1 (bu21) *** Error code 1 (bu21)

DBI-1.08 MAKE/TEST/INSTALL OUTPUT =================================

/work/mSQL/lib/dbi/DBI-1.08/ 9> perl Makefile.PL

*** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The DBI CPAN Bundle may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage.

Optional modules are available from any CPAN mirror, in particular http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

Writing Makefile for DBI

Remember to actually *read* the README file! Build, TEST and INSTALL Perl 5 first. Do NOT build the DBI under the Perl source tree. Use 'make test' to execute self tests. Use 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers.

/work/mSQL/lib/dbi/DBI-1.08/ 10> make

mkdir ./blib mkdir ./blib/lib mkdir ./blib/arch mkdir ./blib/arch/auto mkdir ./blib/arch/auto/DBI mkdir ./blib/lib/auto mkdir ./blib/lib/auto/DBI mkdir ./blib/man1 mkdir ./blib/man3 cp lib/DBI/W32ODBC.pm ./blib/lib/DBI/W32ODBC.pm cp lib/DBD/ExampleP.pm ./blib/lib/DBD/ExampleP.pm cp lib/DBI/FAQ.pm ./blib/lib/DBI/FAQ.pm cp lib/DBI/Shell.pm ./blib/lib/DBI/Shell.pm cp lib/DBI/ProxyServer.pm ./blib/lib/DBI/ProxyServer.pm cp lib/Bundle/DBI.pm ./blib/lib/Bundle/DBI.pm cp lib/DBD/Proxy.pm ./blib/lib/DBD/Proxy.pm cp DBIXS.h ./blib/arch/auto/DBI/DBIXS.h cp dbd_xsh.h ./blib/arch/auto/DBI/dbd_xsh.h cp dbi_sql.h ./blib/arch/auto/DBI/dbi_sql.h cp lib/DBD/NullP.pm ./blib/lib/DBD/NullP.pm cp lib/DBD/Sponge.pm ./blib/lib/DBD/Sponge.pm cp lib/DBI/Format.pm ./blib/lib/DBI/Format.pm cp Driver.xst ./blib/arch/auto/DBI/Driver.xst cp lib/DBI/DBD.pm ./blib/lib/DBI/DBD.pm cp lib/Win32/DBIODBC.pm ./blib/lib/Win32/DBIODBC.pm cp DBI.pm ./blib/lib/DBI.pm cp lib/DBD/ADO.pm ./blib/lib/DBD/ADO.pm /usr/local/bin/perl -p -e "s/~DRIVER~/Perl/g" < ./blib/arch/auto/DBI/Driver.xst > Perl.xsi /usr/local/bin/perl -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 /usr/local/lib/perl5.004/ExtUtils/xsubpp -typemap /usr/local/lib/perl5.004/ExtUtils/typemap Perl.xs >Perl.tc && mv Perl.tc Perl.c cc -c -32 -D_BSD_TYPES -D_BSD_TIME -Olimit 3100 -I/usr/local/include -DLANGUAGE_C -O -DVERSION=\"1.08\" -DXS_VERSION=\"1.08\" -KPIC -I/usr/local/lib/perl5.004/IP20-irix/5.00404/CORE -DDBI_NO_THREADS Perl.c /usr/local/bin/perl -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 /usr/local/lib/perl5.004/ExtUtils/xsubpp -typemap /usr/local/lib/perl5.004/ExtUtils/typemap DBI.xs >DBI.tc && mv DBI.tc DBI.c cc -c -32 -D_BSD_TYPES -D_BSD_TIME -Olimit 3100 -I/usr/local/include -DLANGUAGE_C -O -DVERSION=\"1.08\" -DXS_VERSION=\"1.08\" -KPIC -I/usr/local/lib/perl5.004/IP20-irix/5.00404/CORE -DDBI_NO_THREADS DBI.c Running Mkbootstrap for DBI () chmod 644 DBI.bs LD_RUN_PATH="" cc -o ./blib/arch/auto/DBI/DBI.so -shared -L/usr/local/lib DBI.o chmod 755 ./blib/arch/auto/DBI/DBI.so cp DBI.bs ./blib/arch/auto/DBI/DBI.bs chmod 644 ./blib/arch/auto/DBI/DBI.bs /usr/local/bin/perl -I./blib/arch -I./blib/lib -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 dbiproxy.PL /usr/local/bin/perl -I./blib/arch -I./blib/lib -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 dbish.PL Extracted dbish from dbish.PL with variable substitutions. Manifying ./blib/man1/dbiproxy.1 Manifying ./blib/man3/DBI::W32ODBC.3 Manifying ./blib/man3/DBI::Shell.3 Manifying ./blib/man3/DBI::FAQ.3 Manifying ./blib/man3/DBI::Format.3 Manifying ./blib/man3/DBI::ProxyServer.3 Manifying ./blib/man3/Bundle::DBI.3 Manifying ./blib/man3/DBI::DBD.3 Manifying ./blib/man1/dbish.1 Manifying ./blib/man3/DBI.3 Manifying ./blib/man3/Win32::DBIODBC.3 Manifying ./blib/man3/DBD::Proxy.3 Manifying ./blib/man3/DBD::ADO.3 mkdir ./blib/script cp dbiproxy ./blib/script/dbiproxy /usr/local/bin/perl -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 -MExtUtils::MakeMaker -e "MY->fixin(shift)" ./blib/script/dbiproxy cp dbish ./blib/script/dbish /usr/local/bin/perl -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 -MExtUtils::MakeMaker -e "MY->fixin(shift)" ./blib/script/dbish

/work/mSQL/lib/dbi/DBI-1.08/ 12> make PREFIX=/d/occam/mSQL INSTALLMAN1DIR=/d/occam/mSQL/man INSTALLMAN3DIR=/d/occam/mSQL/man/manl test

PERL_DL_NONLAZY=1 /usr/local/bin/perl -I./blib/arch -I./blib/lib -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/basics............ok t/dbidrv............ok t/examp.............ok t/meta..............ok t/proxy.............skipping test on this platform t/shell.............skipping test on this platform t/subclass..........ok All tests successful. Files=7, Tests=244, 9 secs ( 8.24 cusr 0.70 csys = 8.94 cpu) PERL_DL_NONLAZY=1 /usr/local/bin/perl -I./blib/arch -I./blib/lib -I/usr/local/lib/perl5.004/IP20-irix/5.00404 -I/usr/local/lib/perl5.004 test.pl test.pl DBI test application $Revision: 10.2 $ Using /work/mSQL/lib/dbi/DBI-1.08/blib Switch: DBI-1.08 Switch by Tim Bunce, 1.08 Available Drivers: ADO, ExampleP, Proxy dbi:ExampleP:: testing 5 sets of 20 connections: Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Made 100 connections in 0 secs ( 0.21 usr 0.02 sys = 0.23 cpu)

Testing handle creation speed... 5000 NullP statement handles cycled in 6.8 cpu+sys seconds (735 per sec)

/work/mSQL/lib/dbi/DBI-1.08/ 36> make PREFIX=/d/occam/mSQL INSTALLMAN1DIR=/d/occam/mSQL/man INSTALLMAN3DIR=/d/occam/mSQL/man/manl install

Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/DBI.bs Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/DBI.so Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/Driver.xst Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/dbi_sql.h Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/DBIXS.h Installing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/dbd_xsh.h Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBD/Sponge.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBD/ExampleP.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBD/ADO.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBD/Proxy.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBD/NullP.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/ProxyServer.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/FAQ.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/DBD.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/Format.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/W32ODBC.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI/Shell.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./DBI.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./Bundle/DBI.pm Installing /d/occam/mSQL/lib/perl5.004/site_perl/./Win32/DBIODBC.pm Installing /d/occam/mSQL/man/./dbiproxy.1 Installing /d/occam/mSQL/man/./dbish.1 Installing /d/occam/mSQL/man/manl/./DBI::DBD.3 Installing /d/occam/mSQL/man/manl/./Bundle::DBI.3 Installing /d/occam/mSQL/man/manl/./DBI::FAQ.3 Installing /d/occam/mSQL/man/manl/./DBI::W32ODBC.3 Installing /d/occam/mSQL/man/manl/./DBI.3 Installing /d/occam/mSQL/man/manl/./DBD::ADO.3 Installing /d/occam/mSQL/man/manl/./Win32::DBIODBC.3 Installing /d/occam/mSQL/man/manl/./DBD::Proxy.3 Installing /d/occam/mSQL/man/manl/./DBI::ProxyServer.3 Installing /d/occam/mSQL/man/manl/./DBI::Format.3 Installing /d/occam/mSQL/man/manl/./DBI::Shell.3 Installing /d/occam/mSQL/bin/./dbiproxy Installing /d/occam/mSQL/bin/./dbish Writing /d/occam/mSQL/lib/perl5.004/site_perl/IP20-irix/auto/DBI/.packlist ## Differing version of ./DBI.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBI.pm ## Differing version of DBD/ExampleP.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBD/ExampleP.pm ## Differing version of DBD/NullP.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBD/NullP.pm ## Differing version of DBD/Sponge.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBD/Sponge.pm ## Differing version of DBI/DBD.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBI/DBD.pm ## Differing version of DBI/FAQ.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBI/FAQ.pm ## Differing version of DBI/W32ODBC.pm found. You might like to rm /usr/local/lib/perl5.004/site_perl/./DBI/W32ODBC.pm ## Differing version of auto/DBI/DBI.so found. You might like to rm /usr/local/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/DBI.so ## Differing version of auto/DBI/DBIXS.h found. You might like to rm /usr/local/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/DBIXS.h ## Differing version of auto/DBI/Driver.xst found. You might like to rm /usr/local/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/Driver.xst ## Differing version of auto/DBI/dbd_xsh.h found. You might like to rm /usr/local/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/dbd_xsh.h ## Differing version of auto/DBI/dbi_sql.h found. You might like to rm /usr/local/lib/perl5.004/site_perl/IP20-irix/./auto/DBI/dbi_sql.h ## Running 'make install UNINST=1' will unlink all those files for you. Appending installation info to /d/occam/mSQL/lib/perl5.004/IP20-irix/5.00404/perllocal.pod

perl -V =======================

/work/mSQL/lib/dbd/Msql-Mysql-modules-1.2016/ 79> perl -V

Summary of my perl5 (5.0 patchlevel 4 subversion 4) configuration: Platform: osname=irix, osvers=6.2, archname=IP20-irix uname='irix ratbert 6.2 06101030 ip20 ' hint=recommended, useposix=true, d_sigaction=define bincompat3=y useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-O', gccversion= cppflags='-32 -D_BSD_TYPES -D_BSD_TIME -I/usr/local/include -DLANGUAGE_C' ccflags ='-32 -D_BSD_TYPES -D_BSD_TIME -Olimit 3100 -I/usr/local/include -DLANGUAGE_C' stdchar='unsigned char', d_stdstdio=define, usevfork=false voidflags=15, castflags=1, d_casti32=define, d_castneg=undef intsize=4, alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /usr/lib /lib libs=-lm -lc libc=/usr/lib/libc.so, so=so useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-KPIC', lddlflags='-shared -L/usr/local/lib'

Characteristics of this binary (from libperl): Built under irix Compiled at Jan 26 1998 14:31:20 @INC: /usr/local/lib/perl5.004/IP20-irix/5.00404 /usr/local/lib/perl5.004 /usr/local/lib/perl5.004/site_perl/IP20-irix /usr/local/lib/perl5.004/site_perl .