DBD DB2

Discussion in 'Perl Misc' started by Joydeep Chakrabarty, Apr 23, 2011.

  1. Hello all,

    I am trying to install DBD for DB2. I have downloaded both
    DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    am using Windows 7 64-bit with Active Perl 5.12.3.
    When I try to do nmake on DBD-DB2 it gives me error
    "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    include file: 'windows.h': No such file or directory
    NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    Stop.
    NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    return code '0x2'
    Stop."

    When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    failed: The PPD does not provide code to install for this platform".
    What am I doing wrong here? Please help.

    Thanks,
    Joydeep


    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 23, 2011
    #1
    1. Advertising

  2. Joydeep Chakrabarty

    John Bokma Guest

    Joydeep Chakrabarty <> writes:

    > Hello all,
    >
    > I am trying to install DBD for DB2. I have downloaded both
    > DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    > am using Windows 7 64-bit with Active Perl 5.12.3.
    > When I try to do nmake on DBD-DB2 it gives me error
    > "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    > include file: 'windows.h': No such file or directory
    > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    > Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    > Stop.
    > NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    > return code '0x2'
    > Stop."
    >
    > When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    > failed: The PPD does not provide code to install for this platform".
    > What am I doing wrong here? Please help.


    It looks like you need a C compiler + header files to make this
    module.

    Have you added the alternative repositories to ppm? The ones at
    ActiveState have a limited set of modules.

    --
    John Bokma j3b

    Blog: http://johnbokma.com/ Facebook: http://www.facebook.com/j.j.j.bokma
    Freelance Perl & Python Development: http://castleamber.com/
     
    John Bokma, Apr 23, 2011
    #2
    1. Advertising

  3. John Bokma wrote on 4/23/2011 :
    > Joydeep Chakrabarty <> writes:
    >
    >> Hello all,
    >>
    >> I am trying to install DBD for DB2. I have downloaded both
    >> DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    >> am using Windows 7 64-bit with Active Perl 5.12.3.
    >> When I try to do nmake on DBD-DB2 it gives me error
    >> "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    >> include file: 'windows.h': No such file or directory
    >> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    >> Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    >> Stop.
    >> NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    >> return code '0x2'
    >> Stop."
    >>
    >> When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    >> failed: The PPD does not provide code to install for this platform".
    >> What am I doing wrong here? Please help.

    >
    > It looks like you need a C compiler + header files to make this
    > module.
    >
    > Have you added the alternative repositories to ppm? The ones at
    > ActiveState have a limited set of modules.


    I am using Visual C++ 2008 Express edition. What are the other
    repositories?

    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 23, 2011
    #3
  4. Joydeep Chakrabarty

    John Bokma Guest

    Joydeep Chakrabarty <> writes:

    > John Bokma wrote on 4/23/2011 :
    >> Joydeep Chakrabarty <> writes:
    >>
    >>> Hello all,
    >>>
    >>> I am trying to install DBD for DB2. I have downloaded both
    >>> DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    >>> am using Windows 7 64-bit with Active Perl 5.12.3.
    >>> When I try to do nmake on DBD-DB2 it gives me error
    >>> "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    >>> include file: 'windows.h': No such file or directory
    >>> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    >>> Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    >>> Stop.
    >>> NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    >>> return code '0x2'
    >>> Stop."
    >>>
    >>> When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    >>> failed: The PPD does not provide code to install for this platform".
    >>> What am I doing wrong here? Please help.

    >>
    >> It looks like you need a C compiler + header files to make this
    >> module.
    >>
    >> Have you added the alternative repositories to ppm? The ones at
    >> ActiveState have a limited set of modules.

    >
    > I am using Visual C++ 2008 Express edition. What are the other
    > repositories?


    I would first check if DBD::DB2 is in one of the other repositories you
    can enable in ppm. See the documentation of ppm. Or if you use the GUI
    version: Click on the gray cog icon (right most icon) and the PPM Preferences
    window is opened.

    See also the ppm documentation, which in a default install can be
    reached via the documentation installed at:

    file:///C:/Perl/html/index.html


    --
    John Bokma j3b

    Blog: http://johnbokma.com/ Facebook: http://www.facebook.com/j.j.j.bokma
    Freelance Perl & Python Development: http://castleamber.com/
     
    John Bokma, Apr 23, 2011
    #4
  5. John Bokma laid this down on his screen :
    > Joydeep Chakrabarty <> writes:
    >
    >> John Bokma wrote on 4/23/2011 :
    >>> Joydeep Chakrabarty <> writes:
    >>>
    >>>> Hello all,
    >>>>
    >>>> I am trying to install DBD for DB2. I have downloaded both
    >>>> DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    >>>> am using Windows 7 64-bit with Active Perl 5.12.3.
    >>>> When I try to do nmake on DBD-DB2 it gives me error
    >>>> "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    >>>> include file: 'windows.h': No such file or directory
    >>>> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    >>>> Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    >>>> Stop.
    >>>> NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    >>>> return code '0x2'
    >>>> Stop."
    >>>>
    >>>> When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    >>>> failed: The PPD does not provide code to install for this platform".
    >>>> What am I doing wrong here? Please help.
    >>>
    >>> It looks like you need a C compiler + header files to make this
    >>> module.
    >>>
    >>> Have you added the alternative repositories to ppm? The ones at
    >>> ActiveState have a limited set of modules.

    >>
    >> I am using Visual C++ 2008 Express edition. What are the other
    >> repositories?

    >
    > I would first check if DBD::DB2 is in one of the other repositories you
    > can enable in ppm. See the documentation of ppm. Or if you use the GUI
    > version: Click on the gray cog icon (right most icon) and the PPM Preferences
    > window is opened.
    >
    > See also the ppm documentation, which in a default install can be
    > reached via the documentation installed at:
    >
    > file:///C:/Perl/html/index.html


    While trying to install it through CPAN, I got this error

    cpan> install DBD::DB2
    Running install for module 'DBD::DB2'
    Running make for I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    Fetching with LWP:
    http://ppm.activestate.com/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    Error reading 'C:\Perl64\cpan\FTPstats.yml': Alert: While trying to
    'parse' YAML file
    'C:\Perl64\cpan\FTPstats.yml'
    with 'YAML::XS' the following error was encountered:
    Usage: YAML::XS::LibYAML::Load(yaml_sv) at C:\Perl64\lib/YAML/XS.pm
    line 48.


    Stashing away as 'C:\Perl64\cpan\FTPstats.yml.1303620067' to prevent
    further interruptions. You may want to remove that file later.
    Could not rename: Permission denied

    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 24, 2011
    #5
  6. on 4/24/2011, Joydeep Chakrabarty supposed :
    > John Bokma laid this down on his screen :
    >> Joydeep Chakrabarty <> writes:
    >>
    >>> John Bokma wrote on 4/23/2011 :
    >>>> Joydeep Chakrabarty <> writes:
    >>>>
    >>>>> Hello all,
    >>>>>
    >>>>> I am trying to install DBD for DB2. I have downloaded both
    >>>>> DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    >>>>> am using Windows 7 64-bit with Active Perl 5.12.3.
    >>>>> When I try to do nmake on DBD-DB2 it gives me error
    >>>>> "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    >>>>> include file: 'windows.h': No such file or directory
    >>>>> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    >>>>> Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    >>>>> Stop.
    >>>>> NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    >>>>> return code '0x2'
    >>>>> Stop."
    >>>>>
    >>>>> When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    >>>>> failed: The PPD does not provide code to install for this platform".
    >>>>> What am I doing wrong here? Please help.
    >>>>
    >>>> It looks like you need a C compiler + header files to make this
    >>>> module.
    >>>>
    >>>> Have you added the alternative repositories to ppm? The ones at
    >>>> ActiveState have a limited set of modules.
    >>>
    >>> I am using Visual C++ 2008 Express edition. What are the other
    >>> repositories?

    >>
    >> I would first check if DBD::DB2 is in one of the other repositories you
    >> can enable in ppm. See the documentation of ppm. Or if you use the GUI
    >> version: Click on the gray cog icon (right most icon) and the PPM
    >> Preferences
    >> window is opened.
    >>
    >> See also the ppm documentation, which in a default install can be
    >> reached via the documentation installed at:
    >>
    >> file:///C:/Perl/html/index.html

    >
    > While trying to install it through CPAN, I got this error
    >
    > cpan> install DBD::DB2
    > Running install for module 'DBD::DB2'
    > Running make for I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    > Fetching with LWP:
    > http://ppm.activestate.com/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    > Error reading 'C:\Perl64\cpan\FTPstats.yml': Alert: While trying to 'parse'
    > YAML file
    > 'C:\Perl64\cpan\FTPstats.yml'
    > with 'YAML::XS' the following error was encountered:
    > Usage: YAML::XS::LibYAML::Load(yaml_sv) at C:\Perl64\lib/YAML/XS.pm line
    > 48.
    >
    >
    > Stashing away as 'C:\Perl64\cpan\FTPstats.yml.1303620067' to prevent further
    > interruptions. You may want to remove that file later.
    > Could not rename: Permission denied


    Well, that problem was solved. I changed the Readonly permission on
    Perl64 folder. Then I ran "C:\Program Files (x86)\Microsoft Visual
    Studio 9.0\Common7\Tools\vsvars32.bat". But Now I am getting Linker
    error.

    Constants.obj : fatal error LNK1112: module machine type 'X86'
    conflicts with target machine type 'x64'
    NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    Studio 9.0\VC\BIN\link.EXE"' : return code '0x458'
    Stop.
    NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\BIN\nmake.exe' :
    return code '0x2'
    Stop.

    I am using Windows 7 64-bit. I guess I am using 32-bit DBD-DB2. Where
    can I get 64-bit perl modules?

    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 24, 2011
    #6
  7. Joydeep Chakrabarty has brought this to us :
    > on 4/24/2011, Joydeep Chakrabarty supposed :
    >> John Bokma laid this down on his screen :
    >>> Joydeep Chakrabarty <> writes:
    >>>
    >>>> John Bokma wrote on 4/23/2011 :
    >>>>> Joydeep Chakrabarty <> writes:
    >>>>>
    >>>>>> Hello all,
    >>>>>>
    >>>>>> I am trying to install DBD for DB2. I have downloaded both
    >>>>>> DBD-DB2-1.74.tar.gz and DBD-DB2-1.80a.tar.gz as well as DBD-DB2.ppd. I
    >>>>>> am using Windows 7 64-bit with Active Perl 5.12.3.
    >>>>>> When I try to do nmake on DBD-DB2 it gives me error
    >>>>>> "c:\perl64\lib\core\win32.h(61) : fatal error C1083: Cannot open
    >>>>>> include file: 'windows.h': No such file or directory
    >>>>>> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    >>>>>> Studio 9.0\VC\bin\cl.EXE"' : return code '0x2'
    >>>>>> Stop.
    >>>>>> NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\bin\nmake.exe' :
    >>>>>> return code '0x2'
    >>>>>> Stop."
    >>>>>>
    >>>>>> When I try to ppm install DBD-DB2.ppd, it gives me error "ppm install
    >>>>>> failed: The PPD does not provide code to install for this platform".
    >>>>>> What am I doing wrong here? Please help.
    >>>>>
    >>>>> It looks like you need a C compiler + header files to make this
    >>>>> module.
    >>>>>
    >>>>> Have you added the alternative repositories to ppm? The ones at
    >>>>> ActiveState have a limited set of modules.
    >>>>
    >>>> I am using Visual C++ 2008 Express edition. What are the other
    >>>> repositories?
    >>>
    >>> I would first check if DBD::DB2 is in one of the other repositories you
    >>> can enable in ppm. See the documentation of ppm. Or if you use the GUI
    >>> version: Click on the gray cog icon (right most icon) and the PPM
    >>> Preferences
    >>> window is opened.
    >>>
    >>> See also the ppm documentation, which in a default install can be
    >>> reached via the documentation installed at:
    >>>
    >>> file:///C:/Perl/html/index.html

    >>
    >> While trying to install it through CPAN, I got this error
    >>
    >> cpan> install DBD::DB2
    >> Running install for module 'DBD::DB2'
    >> Running make for I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    >> Fetching with LWP:
    >> http://ppm.activestate.com/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.80a.tar.gz
    >> Error reading 'C:\Perl64\cpan\FTPstats.yml': Alert: While trying to 'parse'
    >> YAML file
    >> 'C:\Perl64\cpan\FTPstats.yml'
    >> with 'YAML::XS' the following error was encountered:
    >> Usage: YAML::XS::LibYAML::Load(yaml_sv) at C:\Perl64\lib/YAML/XS.pm line
    >> 48.
    >>
    >>
    >> Stashing away as 'C:\Perl64\cpan\FTPstats.yml.1303620067' to prevent
    >> further interruptions. You may want to remove that file later.
    >> Could not rename: Permission denied

    >
    > Well, that problem was solved. I changed the Readonly permission on Perl64
    > folder. Then I ran "C:\Program Files (x86)\Microsoft Visual Studio
    > 9.0\Common7\Tools\vsvars32.bat". But Now I am getting Linker error.
    >
    > Constants.obj : fatal error LNK1112: module machine type 'X86' conflicts with
    > target machine type 'x64'
    > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio
    > 9.0\VC\BIN\link.EXE"' : return code '0x458'
    > Stop.
    > NMAKE : fatal error U1077: 'C:\PROGRA~2\MICROS~2.0\VC\BIN\nmake.exe' : return
    > code '0x2'
    > Stop.
    >
    > I am using Windows 7 64-bit. I guess I am using 32-bit DBD-DB2. Where can I
    > get 64-bit perl modules?


    OK, I downloaded Active Perl 32-bit and installed it. DBD::DB2 is not
    included but DBD::Oracle is there and working fine. I ran vsvars32.bat.
    Then from CPAN, when I issued install DBD::DB2, it gave so many
    warnings and finally with these following 6 errors, it stopped.

    dbdimp.obj : error LNK2019: unresolved external symbol _SQLGetLength@20
    referenced in function _get_lob_length
    dbdimp.obj : error LNK2019: unresolved external symbol
    _SQLGetSubString@40 referenced in function _get_lob_data
    dbdimp.obj : error LNK2019: unresolved external symbol _sqledcls_api@8
    referenced in function _db2_data_sources
    dbdimp.obj : error LNK2019: unresolved external symbol _sqledgne_api@12
    referenced in function _db2_data_sources
    dbdimp.obj : error LNK2019: unresolved external symbol _sqledosd_api@16
    referenced in function _db2_data_sources
    dbdimp.obj : error LNK2019: unresolved external symbol
    _SQLBindFileToParam@32 referenced in function _db2_bind_ph
    blib\arch\auto\DBD\DB2\DB2.dll : fatal error LNK1120: 6 unresolved
    externals
    NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
    Studio 9.0\VC\BIN\link.EXE"' : return code '0x460'
    Stop.

    Now, is it Win 7 64-bit OS error or they are in the DBD::DB2 package?
    Please help.


    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 24, 2011
    #7
  8. Joydeep Chakrabarty

    John Bokma Guest

    Joydeep Chakrabarty <> writes:

    > OK, I downloaded Active Perl 32-bit and installed it. DBD::DB2 is not
    > included but DBD::Oracle is there and working fine. I ran
    > vsvars32.bat. Then from CPAN, when I issued install DBD::DB2, it gave
    > so many warnings and finally with these following 6 errors, it
    > stopped.


    Did you follow my earlier advice? Go to ppm and add the additional
    resources. The module(s) you want to install might already be available
    via the alternative repositories. If you use the graphical version of
    ppm, click on the cog icon and check the repositories that are
    available. In the same window you can add several alternative
    repositories which are not added by default.

    --
    John Bokma j3b

    Blog: http://johnbokma.com/ Facebook: http://www.facebook.com/j.j.j.bokma
    Freelance Perl & Python Development: http://castleamber.com/
     
    John Bokma, Apr 24, 2011
    #8
  9. On 04/24/2011 11:50 PM, John Bokma wrote:
    > Joydeep Chakrabarty<> writes:
    >
    >> OK, I downloaded Active Perl 32-bit and installed it. DBD::DB2 is not
    >> included but DBD::Oracle is there and working fine. I ran
    >> vsvars32.bat. Then from CPAN, when I issued install DBD::DB2, it gave
    >> so many warnings and finally with these following 6 errors, it
    >> stopped.

    >
    > Did you follow my earlier advice? Go to ppm and add the additional
    > resources. The module(s) you want to install might already be available
    > via the alternative repositories. If you use the graphical version of
    > ppm, click on the cog icon and check the repositories that are
    > available. In the same window you can add several alternative
    > repositories which are not added by default.
    >


    I added all the repositories that were available in the GUI PPM. But
    DBD::DB2 is not there. Do you know any other repositories that I should
    add to it?
     
    Jaydip Chakrabarty, Apr 25, 2011
    #9
  10. Joydeep Chakrabarty

    Dr.Ruud Guest

    Dr.Ruud, Apr 25, 2011
    #10
  11. Dr.Ruud pretended :
    > On 2011-04-23 17:25, Joydeep Chakrabarty wrote:
    >
    >> I am trying to install DBD for DB2. [...] I
    >> am using Windows 7 64-bit with Active Perl 5.12.3.

    >
    > HTH:
    >
    > http://community.activestate.com/forum/manual-install-perl-dbd-db2-using-ppm-local-drive


    I have already gone through that link. The repository,
    http://ppm4.activestate.com/MSWin32-x86/5.12/1200/package-all.xml is
    the default repository and it's already there in PPM. Moreover DBD::DB2
    is not there in that repository.

    --
    Thanks and regards,
    Joydeep
     
    Joydeep Chakrabarty, Apr 25, 2011
    #11
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    7,684
  2. Dinesh
    Replies:
    0
    Views:
    184
    Dinesh
    Apr 3, 2006
  3. Replies:
    0
    Views:
    196
  4. Hemant Shah

    No more handles error with DBD::DB2 on Linux

    Hemant Shah, Mar 5, 2004, in forum: Perl Misc
    Replies:
    1
    Views:
    209
    L D Jones
    Mar 6, 2004
  5. Jim Cochrane
    Replies:
    0
    Views:
    132
    Jim Cochrane
    Aug 25, 2007
Loading...

Share This Page