Thanks for the reply As per your suggestion we removed the VC environment and installed Mingw and tried the Perl DBD::mysql compilation but some how  its refers the nmake from Visual Studio. not sure where its referring from. completely removed VC reference from the environment settings. Also initially picked up the dmake later its changed to nmake :(.

Generating a dmake-style Makefile
Writing Makefile for Devel::CheckLib
Writing MYMETA.yml and MYMETA.json
  MATTN/Devel-CheckLib-1.14.tar.gz
  C:\Perl\bin\perl.exe Makefile.PL -- OK
    :
    :
    :
to undefined at C:\perl\lib/ExtUtils/Install.pm line 1198.
NMAKE : fatal error U1077: 'C:\Perl\bin\perl.exe' : return code '0x2'
Stop.
  RURBAN/Mock-Config-0.03.tar.gz
  "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\nmake.EXE" -- NOT OK