I finally got DBD:MYSQL to compile on SCO Unix 5.0.4 .

Used gcc ver :

gcc version 2.95 19990728 (release) AND

cc ver:

SCO UNIX Development System Release 5.1.0Ha 25Apr97

I accomplished it by using the following setup:

a) Downloaded binary of Mysql ver 3.22.16a-gamma for SCO 5.0.4 (and the

libgthreads.a,.so files also)

b) Perl 5.005_03 compiled STATIC with "cc"

c) Got Data-ShowTable-3.3 module (see its README file) . (make test gives errors but this is know problem)

d) DBI-1.12 compiled STATIC with "gcc" i.e. I did:

perl Makefile.PL LINKTYPE=static cc=gcc OPTIMIZE="" CCFLAGS="-mcoff -U M_XENIX -D PERL_SCO -D PERL_SCO5"

I had to edit the Makefile.aperl.

** This actually produces an ELF perl which I used **

e) Msql-Msyql-modules-1.2202 compiled with gcc (static ) with above line but I had to edit the Makefile in the ./mysql directory .

f) all modules passed the "make test" except Data-showtable as noted above.

g) Successfully ran "run-all-tests" from ./sql-bench in mysql subdir.

Additional Notes: ELF build will probably work but I havent had chance to try

gcc is required since there is a "long long" type that "cc" has problems with ( 64 bit support ??).

LD_LIBRARY_PATH may have to be set to libgthread directory.

Thanks to all programmers ( Mysql,DBI,Msql-Mysql-modules, and perl) for the help and the great software !