Sybase, freeTDS, Centos

girarde has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Sybase, freeTDS, Centos by ptum (Priest) on May 31, 2006 at 19:38 UTC
There are quite a few posts in Q&A that have to do with this topic. Particularly, you might look at this answer. Personally, I found that I could only get it to work with DBD::Sybase version 0.91 -- I couldn't get later versions to work (and haven't worried about why it didn't work ever since I got it working). I have more complete notes (but I was working on a Solaris 5.9 platform, not Centos) if that doesn't help ... but they're pretty long and I haven't yet posted them to Q&A. No good deed goes unpunished. -- (attributed to) Oscar Wilde	[reply]
Re^2: Sybase, freeTDS, Centos by jfroebe (Parson) on May 31, 2006 at 19:42 UTC
I recommend asking on the sybperl-l@peppler.org mailing list. Instructions on joining the mailing list and/or searching the archives are on Michael Peppler's website. It covers both sybperl and DBD::Sybase Jason L. Froebe Team Sybase member No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1	[reply]
Re: Sybase, freeTDS, Centos by Joost (Canon) on May 31, 2006 at 18:21 UTC
Just maybe you need to have the SYBASE variable set for the "make install" part - which usually runs as root. That's all I've got - I don't know Sybase or centos or MSSQL (I didn't even know you COULD use DBD::Sybase to talk to MSSQL). "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re^2: Sybase, freeTDS, Centos by girarde (Hermit) on Jun 01, 2006 at 15:58 UTC
I can't get to `make install` - it fails during `configure`. I suppose I could press on with `make` without a successful `configure`.	[reply] [d/l] [select]
Re: Sybase, freeTDS, Centos by derby (Abbot) on May 31, 2006 at 18:19 UTC
Set the SYBASE environment variable to the directory that contains your interfaces file. -derby	[reply]
Re^2: Sybase, freeTDS, Centos by girarde (Hermit) on May 31, 2006 at 18:21 UTC
If that is the freetds.conf file, I have done so. It has no effect.	[reply]
Re^3: Sybase, freeTDS, Centos by derby (Abbot) on May 31, 2006 at 18:31 UTC
For install, set SYBASE to the parent directory of the lib that contains the libtds files -- on my ubuntu box, that would be SYBASE=/usr -derby	[reply]
Re: Sybase, freeTDS, Centos by McDarren (Abbot) on Jun 01, 2006 at 00:02 UTC
Have you tried this? (It worked for me)	[reply]
Re^2: Sybase, freeTDS, Centos by girarde (Hermit) on Jun 01, 2006 at 15:24 UTC
Well, I had tried that, and got: root@######### freetds-0.63# ./configure --prefix=/usr/local/freetds --with-tdsver=7.0 checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking how to run the C preprocessor... gcc -E checking for a sed that does not truncate output... /bin/sed checking for egrep... grep -E checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for /usr/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... no checking for c++... no checking for gpp... no checking for aCC... no checking for CC... no checking for cxx... no checking for cc++... no checking for cl... no checking for FCC... no checking for KCC... no checking for RCC... no checking for xlC_r... no checking for xlC... no checking whether we are using the GNU C++ compiler... no checking whether g++ accepts -g... no checking dependency style of g++... none checking how to run the C++ preprocessor... /lib/cpp configure: error: C++ preprocessor "/lib/cpp" fails sanity check See `config.log' for more details. root@######### freetds-0.63# config.log is long enough that you probably don't want it posted here. This is very depressing considering the number of times I have resintalled g++.	[reply]
Re: Sybase, freeTDS, Centos by girarde (Hermit) on Jun 02, 2006 at 19:44 UTC
Installation problems fixed by installing the "current" (2006-05-15) freetds (i.e., happy configure, make, make install of both freetds and DBD::Sybase). Many thanks to all.	[reply]