Hello Anitha. S.
I circled back to this thread to see how you were doing... I see now that I made an error, when you starting talking about cpan and Active Perl, I assumed that you were on >5.24. I see now that you are on 5.24 albeit 32 bit. I am on AS 5.24, 64 bit. This is my Perl -V:
C:>perl -V
Summary of my perl5 (revision 5 version 24 subversion 3) configuration
+:
Platform:
osname=MSWin32, osvers=6.1, archname=MSWin32-x64-multi-thread
uname=''
config_args='undef'
hint=recommended, useposix=true, d_sigaction=undef
useithreads=define, usemultiplicity=define
use64bitint=define, use64bitall=undef, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='C:\Perl64\site\bin\gcc.exe', ccflags =' -s -O2 -DWIN32 -DWIN64
+ -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IM
+PLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-
+bitfields',
optimize='-s -O2',
cppflags='-DWIN32'
ccversion='', gccversion='4.6.3', gccosandvers=''
intsize=4, longsize=4, ptrsize=8, doublesize=8, byteorder=12345678
+, doublekind=3
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=1
+6, longdblkind=3
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='lo
+ng long', lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='C:\Perl64\site\bin\g++.exe', ldflags ='-s -static-libgcc -stat
+ic-libstdc++ -L"C:\Perl64\lib\CORE" -L"C:\MinGW\x86_64-w64-mingw32\li
+b"'
libpth=C:\MinGW\x86_64-w64-mingw32\lib
libs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32
+-ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -l
+mpr -lwinmm -lversion -lodbc32 -lodbccp32 -lcomctl32
perllibs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdl
+g32 -ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_3
+2 -lmpr -lwinmm -lversion -lodbc32 -lodbccp32 -lcomctl32
libc=, so=dll, useshrplib=true, libperl=libperl524.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
cccdlflags=' ', lddlflags='-mdll -s -static-libgcc -static-libstdc
+++ -L"C:\Perl64\lib\CORE" -L"C:\MinGW\x86_64-w64-mingw32\lib"'
Characteristics of this binary (from libperl):
Compile-time options: HAS_TIMES HAVE_INTERP_INTERN MULTIPLICITY
PERLIO_LAYERS PERL_COPY_ON_WRITE
PERL_DONT_CREATE_GVSV
PERL_HASH_FUNC_ONE_AT_A_TIME_HARD
PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS
PERL_MALLOC_WRAP PERL_PRESERVE_IVUV USE_64_BIT
+_INT
USE_ITHREADS USE_LARGE_FILES USE_LOCALE
USE_LOCALE_COLLATE USE_LOCALE_CTYPE
USE_LOCALE_NUMERIC USE_LOCALE_TIME USE_PERLIO
USE_PERL_ATOF USE_SITECUSTOMIZE
Locally applied patches:
ActivePerl Build 2404 [404865]
Built under MSWin32
Compiled at Dec 11 2017 11:09:26
@INC:
C:/Perl64/site/lib/MSWin32-x64-multi-thread
C:/Perl64/site/lib
C:/Perl64/lib
.
C:>
I just installed DBD-mysql on my system and it was easy. You should do it the same way, using PPM.
At the command prompt, just type PPM, A GUI starts, select DBD-mysql and install it. There is nothing to compile, it comes pre-compiled, the longest time is spent generating the local HTML doc pages.
Why doesn't that work?
The idea that perhaps you didn't know about PPM never occurred to me until now. But PPM still works on 5.24. The new Active State way starts with 5.26 and that is one reason why I haven't upgraded yet.
ADDED: While a long job was running for another project, I did fiddle with the new Active State build process. There are some "very rough edges" on this thing and it took some hacking (as expected), but I was able to make V34 64 bit with MySQL, Maria and Postgres and cpan modules. This is a public project and anybody can use this link: special 64 bit Perl with Maria,MySQL . Unfortunately this link will expire at some point. To update an installation like this you should use the Active State State Tool. Its already in the installation download, but you will need the docs to use it.
update again: see also State Tool Cheatsheet