Re: Oracle is included - how about Sybase?

[Matthew Persico]

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
>> 
>>
>> 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

Re: Oracle is included - how about Sybase?

[Matthew Persico]

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

Re: Oracle is included - how about Sybase?

[Matthew Persico]

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

Re: Oracle is included - how about Sybase?

[Daniel Kasak]

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

Re: Oracle is included - how about Sybase?

[Matthew Persico]

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

Re: Oracle is included - how about Sybase?

[kmx]

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

Oracle is included - how about Sybase?

[Matthew Persico]

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