FreeTDS Development Group

[john saylor <jsaylor AT liaison-intl.com>]

hi

Nguyen, Thi X. wrote:
> install_driver(ODBC) failed: Can't load
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/ODBC/OD
> BC.so' for module DBD::ODBC: libodbc.so.1: cannot open shared object
> file: No such file or directory at
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
>  at (eval 10) line 3

i think the problem is that the cron script can't find libodbc.so.1

there are several way to fix this.

a relatively easy way is to add the directory that this file 
[libodbc.so.1] sits in to the environment variable LD_LIBRARY_PATH. you 
might even be able to do this in your script before calling DBI->connect()

$ENV{LD_LIBRARY_PATH} = '/path/to/library';

good luck!

--
\js