RE: Sybase Lib not found while installing DBD::Sybase using FreeTDS

On Thu, 2005-06-23 at 19:38, Chen, Meeilei wrote:
> My sybase is installed under /opt/SYBASE and I used to setup all my
> SYBASE environmental variables to that directory. Now that I need to
> connect to MSSQL also, I installed FreeTDS.  

But *where* did you install freetds?
Where are the FreeTDS libraries located?

> The FreeTDS documentation says that ENV(SYBASE) needs to be set to
> /usr/local/freetds. Does Freetds installation suppose to put lib under
> /usr/local/freetds? Or should I use my original Sybase library?

You can't use the Sybase libs to talk to MS-SQL.

Michael


> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> On Behalf Of Michael Peppler
> Sent: Thursday, June 23, 2005 12:28 PM
> To: [email protected]
> Subject: Re: Sybase Lib not found while installing DBD::Sybase using
> FreeTDS
> 
> 
> On Thu, 2005-06-23 at 18:25, Chen, Meeilei wrote:
> > I am trying to use Perl program to connect to both Sybase and MSSQL.
> > 
> > I have Perl 5.84 & Sybase 12.5 on HPUX box running 11.0. The MSSQL is
> on
> > a window SQL server 2000 
> > 
> > I installed FreeTDS .63.
> > And I set env(SYBASE) to /usr/local/freetds and unset Sybase_ocs and
> > LD_Library_path. when I tried to install DBD Sybase 1.04 I got message
> > that "Can't find the lib directory under /usr/local/freetds" and there
> > is no lib directory under the /usr/local/freetds. What am I missing?
> 
> Well - if the lib directory isn't under /usr/local/freetds, then where
> is it?
> 
> That's the main question - DBD::Sybase uses the SYBASE env. variable to
> locate the lib and include directories that it needs to build...
> 
> Michael
-- 
Michael Peppler  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html