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