freddybill452005 has asked for the wisdom of the Perl Monks concerning the following question:

We are installing Perl 5.14.2 to support our current Windows XP environment and to support our future move to Windows 7. Our team uses sybase databases and requires access via Perl for reports. Our last Perl install was version 5.6. so this move to 5.14.2 is a big jump for us. We can not seem to find a DBD-Sybase ppd for versions beyond 5.6. Is there one? I am somewhat new to Perl development and don't understand much about the inner workings of Perl modules or how they are created. I have found a CPAN site that indicates that there are no binary builds available because of errors during the build process. Can that be corrected so that there CAN be a valid build for Windows? Thanks so much for your help.

We are currently using the Perl 5.6 version of DBD::Sybase to access our Sybase databases. Can that set of modules be used with 5.14.2? What would need to be changed in 5.14.2 to use the 5.6 modules? Thanks again.

Replies are listed 'Best First'.
Re: DB-Sybase ppd
by tobyink (Canon) on Jul 10, 2012 at 22:16 UTC

    Microsoft SQL Server started out as a fork of Sybase, and although it's been almost completely rewritten since, I believe it retains pretty good API compatibility. So, bearing that in mind, although I have no experience using Sybase, hopefully this will help...

    DBD::ODBC works very well on Windows for connecting to Microsoft SQL Server. If you have a valid ODBC DSN, that can be converted to a DBI DSN by prepending "dbi:ODBC:".

    perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'

      We are currently using the Perl 5.6 version of DBD::Sybase to access our Sybase databases. Can that set of modules be used with 5.14.2? What would need to be changed in 5.14.2 to use the 5.6 modules? Thanks again.

        DBD::Sybase supports recent versions of Perl. You'd need to re-install it for a new installation of Perl, as it includes XS parts.

        perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'
Re: DB-Sybase ppd
by linuxkid (Sexton) on Jul 11, 2012 at 02:31 UTC

    Try strawberry perl, and when installing via CPAN, use force

    --linuxkid


    imrunningoutofideas.co.cc
Re: DB-Sybase ppd
by Anonymous Monk on Jul 11, 2012 at 08:40 UTC

    I have found a CPAN site that indicates that there are no binary builds available because of errors during the build process. Can that be corrected so that there CAN be a valid build for Windows?

    Not really.