FreeTDS Development Group

[Scott Gregory <listaccount AT earthlink.net>]

Thanks for the help.  I added the LD_LIBRARY_PATH and SYBASE to my cron
environment and its working now (I knew it was an easy fix, I just wasn't 
awake enough to see it). Looking back through the docs
(DBD::Sybase) is says I can set SYBASE in a BEGIN block.  From your reply
I am assuming that LD_LIBRARY_PATH cannot be set the same way, it MUST be
set before perl cranks up.  I guess perl doesn't use the modified
environment when it looks for additional libraries.  Bummer.

Thanks for your help and thanks for an excellent product.  I've been
pounding against MS SQL Server and everything is working great!!

Thanks again,

Scott



In the docs for FreeTDS it states to
place the LD_LIBRARY_PATH and SYBASE env variables in the script in a
BEGIN block.......Is this correct?

On Tue, 4 Dec 2001, Michael Peppler wrote:

> listaccount AT earthlink.net writes:
>  > To All,
>  > 
>  > I know I'm missing something very easy, so here is my problem:
>  > 
>  > My perl script runs fine when I run it from the command line, however 
> when
>  > I run it from a cron job I get the following error:
>  > 
>  > "install_driver(Sybase) failed: Can't load
>  > 
> '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/Sybase/Sybase.so'
>  > for module DBD::Sybase: Shared object
>  > "libct.so.0" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line
>  > 169, <CONFIG_FILE> chunk 55."
>  > 
>  > LD_LIBRARY_PATH, SYBASE, and DSQUERY are all set before loading the DBI
>  > and attempting to connect to the DB.
> 
> If you set LD_LIBRARY_PATH in the script itself then that's a problem
> - it will not work.
> 
> You have to set LD_LIBRARY_PATH in the parent process.
> 
> Michael
> -- 
> Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
> mpeppler AT peppler.org - mpeppler AT mbay.net
> International Sybase User Group - http://www.isug.com
> 
> ---
> You are currently subscribed to freetds as: [listaccount AT earthlink.net]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>