FAQ
I see that DBD::Oracle is now included in Strawberry. I'd like to see
DBD::Sybase also included. I assume the steps to doing so are:

1) Identify a FREE downloadable client library package for Sybase, a'la
Oracle Insta-client
2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem for
your automation if the make prompts for input or can you ignore it?
3) Sumbit "something" to "someone" in order to include. This, of course, is
where I need info. :-) Do I pull down a git, modify and create a pull
request somewhere? Is there an FAQ on this I missed?

Thanks


--
Matthew O. Persico

Search Discussions

  • Kmx at Dec 3, 2014 at 7:04 pm

    On 1.12.2014 16:23, Matthew Persico wrote:
    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.
    Well, I have included Oracle DB driver as it is IMO commercial DB No.1. I
    am not sure how popular Sybase DB is nowadays and how big is its user base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.

    I assume the steps to doing so are:

    1) Identify a FREE downloadable client library package for Sybase, a'la
    Oracle Insta-client
    Have you done some research in this area?

    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem for
    your automation if the make prompts for input or can you ignore it?
    Interaction has to be avoided (either by setting proper env variables or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).

    And it also matters how many megabytes does DBD::Sybase add to strawberry perl.
    3) Sumbit "something" to "someone" in order to include. This, of course,
    is where I need info. :-) Do I pull down a git, modify and create a pull
    request somewhere? Is there an FAQ on this I missed?
    All modules bundled with strawberry perl are built from sources at "release
    build time". I am not in favor of including packages built by some else.

    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase
    client library)

    And as you might guess the Sybase client library must be available for free
    and for both 32/64bit MS Windows.



    Anyway, do not take this e-mail as a promise of any kind :)

    --
    kmx
  • Matthew Persico at Dec 3, 2014 at 7:10 pm

    On Wednesday, December 3, 2014, kmx wrote:
    On 1.12.2014 16:23, Matthew Persico wrote:

    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.
    Well, I have included Oracle DB driver as it is IMO commercial DB No.1. I
    am not sure how popular Sybase DB is nowadays and how big is its user base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.
    I assume the steps to doing so are:
    1) Identify a FREE downloadable client library package for Sybase, a'la
    Oracle Insta-client
    Have you done some research in this area?


    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem for
    your automation if the make prompts for input or can you ignore it?
    Interaction has to be avoided (either by setting proper env variables or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).

    And it also matters how many megabytes does DBD::Sybase add to strawberry
    perl.

    3) Sumbit "something" to "someone" in order to include. This, of course,
    is where I need info. :-) Do I pull down a git, modify and create a pull
    request somewhere? Is there an FAQ on this I missed?
    All modules bundled with strawberry perl are built from sources at
    "release build time". I am not in favor of including packages built by some
    else.

    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase
    client library)

    And as you might guess the Sybase client library must be available for
    free and for both 32/64bit MS Windows.



    Anyway, do not take this e-mail as a promise of any kind :)

    --
    kmx

    --
    Matthew O. Persico
  • Daniel Kasak at Dec 3, 2014 at 10:38 pm
    There are a few options for Sybase: http://www.freetds.org/userguide/perl.htm

    I use FreeTDS + unixODBC + DBD::ODBC for SQL Server on Linux. If
    you're after cross-platform support, I recommend using DBD::ODBC - in
    particular because Windows drivers will almost always be ODBC drivers,
    meaning you only need to build DBD::ODBC and nothing else, which is
    fantastic when in Windows and compiling is a PITA :) Having said that,
    I've only ever used Sybase @ university, so I'm not sure of what
    options are around, other than that link above.

    I currently have Strawberry Perl with quite a few add-ons ( including
    DBD::ODBC ), and a build system of sorts, for my own use ( no-one else
    appears particularly interested at this point ). If you're really
    stuck, email me and I'll look at building things for you, but keep in
    mind, at this point, you'll get an all-on-one zip file, including my
    particular version of Strawberry, lots of other things, and Sybase
    drivers as well. This may or may not be fine. I'm open to coming up
    with a better solution ( ie the ability to build individual binary
    packages, but with *me* being the only person using what I've built,
    it hardly seems worthwhile.

    Dan

    On Thu, Dec 4, 2014 at 6:10 AM, Matthew Persico
    wrote:
    On Wednesday, December 3, 2014, kmx wrote:
    On 1.12.2014 16:23, Matthew Persico wrote:

    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.

    Well, I have included Oracle DB driver as it is IMO commercial DB No.1. I
    am not sure how popular Sybase DB is nowadays and how big is its user base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.


    I assume the steps to doing so are:

    1) Identify a FREE downloadable client library package for Sybase, a'la
    Oracle Insta-client

    Have you done some research in this area?

    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem for
    your automation if the make prompts for input or can you ignore it?

    Interaction has to be avoided (either by setting proper env variables or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).

    And it also matters how many megabytes does DBD::Sybase add to strawberry
    perl.
    3) Sumbit "something" to "someone" in order to include. This, of course,
    is where I need info. :-) Do I pull down a git, modify and create a pull
    request somewhere? Is there an FAQ on this I missed?

    All modules bundled with strawberry perl are built from sources at
    "release build time". I am not in favor of including packages built by some
    else.

    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase client
    library)

    And as you might guess the Sybase client library must be available for
    free and for both 32/64bit MS Windows.



    Anyway, do not take this e-mail as a promise of any kind :)

    --
    kmx


    --
    Matthew O. Persico
  • Matthew Persico at Dec 4, 2014 at 1:23 am
    We've tried FreeTDS in the past at my current gig - not reliable.

    We're connecting to a boatload of Sybase databases from UNIX boxes - I'm
    trying to distribute the work over underutilized Windows boxes without
    rewriting the world, so ODBC in this case is not applicable.
    On Wed, Dec 3, 2014 at 5:38 PM, Daniel Kasak wrote:

    There are a few options for Sybase:
    http://www.freetds.org/userguide/perl.htm

    I use FreeTDS + unixODBC + DBD::ODBC for SQL Server on Linux. If
    you're after cross-platform support, I recommend using DBD::ODBC - in
    particular because Windows drivers will almost always be ODBC drivers,
    meaning you only need to build DBD::ODBC and nothing else, which is
    fantastic when in Windows and compiling is a PITA :) Having said that,
    I've only ever used Sybase @ university, so I'm not sure of what
    options are around, other than that link above.

    I currently have Strawberry Perl with quite a few add-ons ( including
    DBD::ODBC ), and a build system of sorts, for my own use ( no-one else
    appears particularly interested at this point ). If you're really
    stuck, email me and I'll look at building things for you, but keep in
    mind, at this point, you'll get an all-on-one zip file, including my
    particular version of Strawberry, lots of other things, and Sybase
    drivers as well. This may or may not be fine. I'm open to coming up
    with a better solution ( ie the ability to build individual binary
    packages, but with *me* being the only person using what I've built,
    it hardly seems worthwhile.

    Dan

    On Thu, Dec 4, 2014 at 6:10 AM, Matthew Persico
    wrote:
    On Wednesday, December 3, 2014, kmx wrote:
    On 1.12.2014 16:23, Matthew Persico wrote:

    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.

    Well, I have included Oracle DB driver as it is IMO commercial DB No.1.
    I
    am not sure how popular Sybase DB is nowadays and how big is its user
    base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.


    I assume the steps to doing so are:

    1) Identify a FREE downloadable client library package for Sybase, a'la
    Oracle Insta-client

    Have you done some research in this area?

    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem
    for
    your automation if the make prompts for input or can you ignore it?

    Interaction has to be avoided (either by setting proper env variables or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).

    And it also matters how many megabytes does DBD::Sybase add to
    strawberry
    perl.
    3) Sumbit "something" to "someone" in order to include. This, of
    course,
    is where I need info. :-) Do I pull down a git, modify and create a
    pull
    request somewhere? Is there an FAQ on this I missed?

    All modules bundled with strawberry perl are built from sources at
    "release build time". I am not in favor of including packages built by
    some
    else.

    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase
    client
    library)

    And as you might guess the Sybase client library must be available for
    free and for both 32/64bit MS Windows.



    Anyway, do not take this e-mail as a promise of any kind :)

    --
    kmx


    --
    Matthew O. Persico


    --
    Matthew O. Persico
  • Matthew Persico at Dec 4, 2014 at 1:24 am
    But thanks for the offer.
    On Wed, Dec 3, 2014 at 8:23 PM, Matthew Persico wrote:

    We've tried FreeTDS in the past at my current gig - not reliable.

    We're connecting to a boatload of Sybase databases from UNIX boxes - I'm
    trying to distribute the work over underutilized Windows boxes without
    rewriting the world, so ODBC in this case is not applicable.
    On Wed, Dec 3, 2014 at 5:38 PM, Daniel Kasak wrote:

    There are a few options for Sybase:
    http://www.freetds.org/userguide/perl.htm
    <http://t.signauxdix.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg1px69sN3MqgJWRrZJ4VQBcsP56dWp2f5XP34x02?t=http%3A%2F%2Fwww.freetds.org%2Fuserguide%2Fperl.htm&si=6421569248165888&pi=3114b721-a17d-4a0f-dd21-8b14cbed5895>

    I use FreeTDS + unixODBC + DBD::ODBC for SQL Server on Linux. If
    you're after cross-platform support, I recommend using DBD::ODBC - in
    particular because Windows drivers will almost always be ODBC drivers,
    meaning you only need to build DBD::ODBC and nothing else, which is
    fantastic when in Windows and compiling is a PITA :) Having said that,
    I've only ever used Sybase @ university, so I'm not sure of what
    options are around, other than that link above.

    I currently have Strawberry Perl with quite a few add-ons ( including
    DBD::ODBC ), and a build system of sorts, for my own use ( no-one else
    appears particularly interested at this point ). If you're really
    stuck, email me and I'll look at building things for you, but keep in
    mind, at this point, you'll get an all-on-one zip file, including my
    particular version of Strawberry, lots of other things, and Sybase
    drivers as well. This may or may not be fine. I'm open to coming up
    with a better solution ( ie the ability to build individual binary
    packages, but with *me* being the only person using what I've built,
    it hardly seems worthwhile.

    Dan

    On Thu, Dec 4, 2014 at 6:10 AM, Matthew Persico
    wrote:
    On Wednesday, December 3, 2014, kmx wrote:
    On 1.12.2014 16:23, Matthew Persico wrote:

    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.

    Well, I have included Oracle DB driver as it is IMO commercial DB
    No.1. I
    am not sure how popular Sybase DB is nowadays and how big is its user
    base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.


    I assume the steps to doing so are:

    1) Identify a FREE downloadable client library package for Sybase,
    a'la
    Oracle Insta-client

    Have you done some research in this area?

    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem
    for
    your automation if the make prompts for input or can you ignore it?

    Interaction has to be avoided (either by setting proper env variables
    or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).

    And it also matters how many megabytes does DBD::Sybase add to
    strawberry
    perl.
    3) Sumbit "something" to "someone" in order to include. This, of
    course,
    is where I need info. :-) Do I pull down a git, modify and create a
    pull
    request somewhere? Is there an FAQ on this I missed?

    All modules bundled with strawberry perl are built from sources at
    "release build time". I am not in favor of including packages built by
    some
    else.

    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase
    client
    library)

    And as you might guess the Sybase client library must be available for
    free and for both 32/64bit MS Windows.



    Anyway, do not take this e-mail as a promise of any kind :)

    --
    kmx


    --
    Matthew O. Persico


    --
    Matthew O. Persico


    --
    Matthew O. Persico
  • Matthew Persico at Dec 4, 2014 at 1:21 am

    On Wed, Dec 3, 2014 at 2:04 PM, kmx wrote:
    On 1.12.2014 16:23, Matthew Persico wrote:

    I see that DBD::Oracle is now included in Strawberry. I'd like to see
    DBD::Sybase also included.
    Well, I have included Oracle DB driver as it is IMO commercial DB No.1. I
    am not sure how popular Sybase DB is nowadays and how big is its user base
    (esp. among potential strawberry perl users).

    The other think is that my Oracle DB related knowledge is quite good
    whereas I know literally nothing about Sybase DB.

    That;s ok - I wasn't expecting YOU to do the work.
    I assume the steps to doing so are:
    1) Identify a FREE downloadable client library package for Sybase, a'la
    Oracle Insta-client
    Have you done some research in this area?

    Yes. I believe SAP still provides a clean free user client. I have to
    review since Sybase has been bought by SAP. If I'm wrong, QED.
    2) Build using Strawberry
    One problem is that the make requires interaction. Is it a problem for
    your automation if the make prompts for input or can you ignore it?
    Interaction has to be avoided (either by setting proper env variables or
    passing proper command line params to Makefile.PL/Build.PL).

    The most important think is that we need DBD::Sybase to be built with
    gcc/mingw-w64 compiler (quite often various SDK's come only with *.lib
    libraries suitable for MSVC compiler).
    I currently build DBD::Sybase in Strawberry - the full-blown client install
    provides the proper files. I hope the free sdk does.

    And it also matters how many megabytes does DBD::Sybase add to strawberry
    perl.

    Not more than Oracle, esp if the libs are in an externally installed
    client.
    3) Sumbit "something" to "someone" in order to include. This, of course,
    is where I need info. :-) Do I pull down a git, modify and create a pull
    request somewhere? Is there an FAQ on this I missed?
    All modules bundled with strawberry perl are built from sources at
    "release build time". I am not in favor of including packages built by some
    else.
    Of course. But I assume that I just can't say "it works, go add it." Don't
    I have to give you something? A Bundle file? Some commands? Do I downoad
    the Strawberry Perl module from some git server and send you a pul request?
    So there must be a functional unattended installation scenarion how to
    build DBD::Sybase with gcc/mingw-w64 (+ obviously some kind of Sybase
    client library)

    And as you might guess the Sybase client library must be available for
    free and for both 32/64bit MS Windows.

    Hmm. That may be the deal breaker - I've only got it to successfully work
    with the 32 bit version.
    Anyway, do not take this e-mail as a promise of any kind :)
    None taken. At least I know you'll consider it so it's worth my while to
    continue research.

    Thanks
    --
    kmx


    --
    Matthew O. Persico

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupwin32-vanilla @
categoriesperl
postedDec 1, '14 at 3:23p
activeDec 4, '14 at 1:24a
posts7
users3
websitestrawberryperl.com

People

Translate

site design / logo © 2019 Grokbase