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