Re: Accessing sql server from perl using dblib/ctlib and freetds

Could someone please suggest if the recompile of Sybase::DBlib and Sybase::CTlib is required after installation of FreeTDS? This is to ensure that the DBlib and CTlib are pointing to FreeTDS libs instead of Sybase libs.

I'm thinking it is required because Sybase::DBlib and Sybase::CTlib pre-installation instructions says that the SYBASE path need to be exported. Is this reasoning correct?

Comment on Re: Accessing sql server from perl using dblib/ctlib and freetds

Replies are listed 'Best First'.
Re^2: Accessing sql server from perl using dblib/ctlib and freetds by Anonyrnous Monk (Hermit) on Dec 20, 2010 at 16:37 UTC
Most likely, yes, you'll need to recompile them. There's a remote chance it might not be required — this would be under the following circumstances: the FreeTDS libs are 100% interface (API) and binary (ABI) compatible with the Sybase libs, i.e. a drop-in replacement (not sure if this is the case) the new libs are actually found at runtime (e.g. via appropriate LD_LIBRARY_PATH settings) You can always check with ldd which dependent libraries are being pulled in (if any) by your old `DBlib.so` and `CTlib.so`. Make sure you call it from within the right environment.	[reply] [d/l] [select]
Re^3: Accessing sql server from perl using dblib/ctlib and freetds by Anonymous Monk on Dec 21, 2010 at 19:02 UTC
Thanks again Anonyrnous Monk. Yes, I ended up recompiling the DBlib.so and CTlib.so. The 'ldd' showed that it was pointing to the Sybase libs	[reply]
Re^2: Accessing sql server from perl using dblib/ctlib and freetds by mpeppler (Vicar) on Jan 20, 2011 at 10:04 UTC
Yes, recompilation is necessary - because although FreeTDS tries to be binary compatible with Sybase OpenClient they aren't there 100%. Michael	[reply]