But thanks for the offer. On Wed, Dec 3, 2014 at 8:23 PM, Matthew Persico <matthew.pers...@gmail.com> 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 <d.j.kasak...@gmail.com> > 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 >> <matthew.pers...@gmail.com> wrote: >> > >> > >> > On Wednesday, December 3, 2014, kmx <k...@atlas.cz> 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