Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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

by Anonymous Monk
on Dec 20, 2010 at 15:18 UTC ( #878032=note: print w/replies, xml ) Need Help??


in reply to 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.

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://878032]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (8)
As of 2020-11-26 09:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?